Shortcut Joins
Shortcut joins allow you to define an alternative, faster join path between two tables. Without the use of a shortcut join, your query would need to go through a huge fact table to create simple reference lists. To the unsuspecting user, this type of query could take hours.
To help you understand shortcut joins, consider a data foundation that includes orders, products, and plants. Products can be ordered, and plants manufacture products. Figure 6-8 shows an example of a shortcut join between the PLANT table and the PRODUCTS table. If the shortcut join were a normal join, the IDT would detect a loop. If you did not define a shortcut join and users wanted a list of which plants made which products, their query would be forced to ...
Get SAP BusinessObjects BI 4.0 The Complete Reference 3/E now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
