CHAPTER 22Complex Queries
We initially covered queries in Chapter 19. In this chapter, we will cover queries in more depth.
One of Web Intelligence’s greatest strengths is the ability to create complex queries and answer complex business questions easily. The powerful semantic layer via the universe lets you create complex SQL statements, without your ever needing to know or write SQL.
We use the term complex query to refer to any query that has these characteristics:
• Generates SQL that is more than a straightforward SELECT and GROUP BY statement
• Leverages features that you may not necessarily use on a routine basis
• Potentially has an adverse effect on response time
• May lead you to incorrect results if you lack a clear understanding of ...
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.
