Some Caveats About SQL Functions
A number of SQL commands are common to all databases. However, database vendors have added a number of extensions to make SQL more powerful. These extensions are not common for all databases. Some companies have development policies to keep the universe database-agnostic, particularly when they are contemplating migrating to a new RDBMS. OEM vendors that use SAP BusinessObjects as the reporting engine also may strive to keep their universes database-agnostic. However, when you avoid using database-specific SQL in the universe, you are generally forcing end users to do more work in the reports. Our recommendation is to use your database SQL to its fullest. Your universe will be more powerful, and you will save ...
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.
