Derived Tables
Derived tables are similar to views in the database, but as they are defined in the universe in the data foundation, they give universe designers more flexibility. A derived table is a query that can be referenced by a universe designer as a table.
As derived tables are queries, and not physical tables, it’s important to understand that the same performance issues that affect queries also affect derived tables:
• Do not use derived tables in place of aggregate tables. Aggregate tables must be physical tables built by the DBA to provide fast query performance.
• Do use derived tables that minimize the complexity of the queries users need to create themselves.
• Do use derived tables in place of views and stored procedures that in ...
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.
