Object Equal to Object from this Query
Setting an object equal to another object from this query is a powerful capability, but as with other complex queries, you need to monitor query performance. This type of query creates a join between the tables that reference the objects (or creates a self-join when the two objects refer to the same table). You may use this capability to answer questions such as the following:
• Which orders shipped the same day the order was placed?
• Which customers traveled to a different country than the one in which they reside?
• Which invoices have the same ship-to customer ID and sold-to customer ID?
The following example looks for customers who traveled to a country different from the one in which they reside. 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.