Create a shortcut join – Information design tool

If you have multiple tables in your SAP Business Objects universe and you are pulling data from only two table which are linked through intermediate tables then your performance goes down as it would require multiple WHERE clauses or JOINS as it increases Join path. Shortcut Join is a join with alternative path between two tables.

It reduces join path by not taking into account intermediate tables. It is represented with dotted line.

When you pull data using shortcut join then it ignores intermediate tables and uses shortcut path hence increase in performance.

In above scenario , even though it looks like a loop but it’s not. Shortcut join would not create any loop. It would increase response time and will get the data from the dotted line tables (i.e Country and Customer).

Leave a Reply