Hi Guys,
I had a question regarding loops. Business scenario is as below:
I have three tables Product, Region, Agents. Product is linked to Region, Region is linked to Agents, and Agents is linked to Products.
However all the three are dimensions. Will it be considered as a loop?
Or do we need to fact/facts in between to become a loop?
Rgds,
SRC.
Quote from: cognos_sourabh on 09 Dec 2014 10:32:23 PM
Hi Guys,
I had a question regarding loops. Business scenario is as below:
I have three tables Product, Region, Agents. Product is linked to Region, Region is linked to Agents, and Agents is linked to Products.
However all the three are dimensions. Will it be considered as a loop?
Or do we need to fact/facts in between to become a loop?
Rgds,
SRC.
This sounds to me like a loop, yes. From what you describe:
A Region has Products
A Region has Agents
Agents have Products
Is this correct?
If so, you need to split this loop apart using an alias shortcut for Products
One leg will be Regions -> Agents -> Products
The other leg will be Regions -> Products Alias
MF.
Hi,
Does it means that you can have a loop not only when using a fact table and dimensions but you can end up with a loop if you only have dimensions involved also ?
What about if the ALIAS Shortcut created ? Do we also need to link it to all other tables or dimensions it might already bee linked besides with the table that its link created a loop ?