BusinessObjects Board

Help needed in context and short cut joins..

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


sathish.sap (BOB member since 2013-08-18)

Please read this thread.


Nick Daniels :uk: (BOB member since 2002-08-15)

Thank u… Thanks for ur link… :slight_smile:


sathish.sap (BOB member since 2013-08-18)

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.


Andreas :de: (BOB member since 2002-06-20)

Thanks a lot for ur reply…


sathish.sap (BOB member since 2013-08-18)