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.