Dear Experts,
We r having three tables for Ex. Sales, Region, Country.
While joining this Loop occurs… To resolve this I’m applying short cut join,
Why i should not use context in this… Pls tell me in which scenario we have to use context and Short cut join…
Thanks,
Kind Regards,
Sathish Kumar.N
And also I am repeating myself and other people’s opinion:
Most important shortcut joins are no way to resolve loops, they are meant as the name suggests as a shortcut and purly for performance reasons. Shortcut joins should come into place after you resolved ALL other issues such as loops, fan/chasm traps, etc.
As a rule of thumb:
If you have multiple fact tables use universe contexts to resolve any so called chasm traps (which unresolved would lead to under- or overstated measures).
If your dimension tables play multiple roles such as “Shipping FROM adress” and “Shipping TO Adress” then use alias.