BusinessObjects Board

What will be the best choice ALIAS or SHORTCUT JOIN

hi everybody,

I have two choice, I can use alias or shortcut join.
I wonder that, Is there any performance difference between them?? which one will be the best solution.

thanks…


bz.ilyasoglu (BOB member since 2010-11-10)

Welcome to B:bob:B!

Please go through this sticky topic where using aliases and/or contexts in a universe is discussed:


Marek Chladny :slovakia: (BOB member since 2003-11-27)

Shortcut joins are not a substitute for aliases or contexts. Make your universe work first. Then consider adding shortcuts for performance reasons. The topic linked previously does a nice job of discussing the differences between aliases and contexts for loops, but it does not really cover shortcuts because they’re not equivalent.

I wrote a somewhat lengthy blog post on shortcuts that contains a lot more information than I want to repeat here (which is why I wrote it to begin with).


Dave Rathbun :us: (BOB member since 2002-06-06)

think about that, for example I have a table and it is the left farest leaf of our fact table and other is the right leaf of our fact table, I can join these two with shortcut or instead of this I can create an alias table of left table and join these two.
I wonder that which one will show the best performance??

thanx…


bz.ilyasoglu (BOB member since 2010-11-10)