Summary
Much of the power in Web Intelligence lies in its robust query capabilities. It can handle complex database schemas by allowing you to generate multiple SQL statements to present one seamless report. In some cases, such as with multipass SQL, you may never realize this happens. In other queries, you may explicitly create separate queries and merge them.
As you create complex queries, be aware that the queries may run slower, and you should ideally test your query logic with small data sets. In some cases, there is no way around the performance issues—it’s a complex business question answered with complex SQL. In other instances, you may be able to construct the query in ways that help the processing, or the DBA may be able to do some ...
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.
