Shortcut Join

[#1]

Hi,

I would like to know whether Shortcut join is required or not for the below table structure (Data Foundation):

I have joined the tables using equi-join.

There are more columns in each table and I am using the columns from all these tables in Business Layer to result in Webi report.

Should I join the table A and D for better performance? Can I join the other tables too like A and C, C and D?

Version: BO 4.1

Thanks in advance.

[former_member4998]

Hi

You can join Table A to Table D (If both the tables have common field) same as other tables.

Shortcut join act as normal join and not cause the loop. and it is a join that joins tables (A and D) by bypassing middle table (D) that exist in the universe.

Normally shortcut joins are used to generate more efficient query by reducing the joins in the query and improves the performance of the query by not taking into account intermediate tables.

Please find the below link for more info

http://www.dagira.com/2010/05/27/everything-about-shortcut-joins/

http://www.dagira.com/2010/05/27/everything-about-shortcut-joins/3/