Forum Discussion
Indicator using inactive relationship
Hi everyone, Likely this has been answered previously, but can't find the correct search term to get hits. I've got a setup (simplified below), containing 2 date tables (Calendar and Periods)...
the concept of inactive relationships is about something else entirely. It is targeted for scenarios where you need to connect ONE calendar table multiple times with ONE fact table, for example a transaction table that has order dates,shipping dates, invoice dates and delivery dates.
You cannot abuse the concept of USERELATIONSHIP to avoid circular references.
Thank you Ibendlin for not providing an answer to the question at hand. I have not referenced Userelationship, nor used it in this question.
Have you considered using TREATAS or LOOKUPVALUE instead?