Multipass Queries
For certain business questions, you may need to issue multiple queries to arrive at your desired result. Web Intelligence’s ability to generate multiple SQL statements and present them to you as one report is referred to as multipass SQL. In some cases, you, as the query author, may explicitly create two distinct queries. In other cases, Web Intelligence will do this for you automatically if your universe contains contexts or derived tables.
When Web Intelligence creates multiple SELECT statements automatically, from the report designer perspective, there is only one data provider; it appears that you are building one query. Web Intelligence automatically generates multiple SQL statements and dynamically stitches the results ...
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.
