CHAPTER 9Beyond the Basics
In the previous chapters, you created some basic dimensions and measures. In this chapter, you will add more intelligence to columns of information. The IDT provides two main categories of functionality to do this: internal IDT functions and SQL functions that are RDBMS-specific. The first part of the chapter covers functionality that is specific to the IDT but database-independent.
Certain capabilities, such as derived tables, are available in the data foundation. Others, such as aggregate awareness and advanced SQL, are accessed in the business layer. The second part of the chapter covers SQL commands that may be dependent on which RDBMS you use.
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.
