Derived tables are the logical tables that you define in the universe designer. Every column in the derived table must be provided with an alias name to name the columns.
Derived tables are like database views the only difference is you can include @functions in a derived table.
You can include complex functions and calculations in a derived table these actions are performed before the result set is returned to the document.A Derived Table is a logical table created in Business Objects Universe using an SQL query. A derived table in a universe is analogous to a view created in database with a SELECT statement.
Disadvantages if derived table.
Since derived table is not an actual table you may face performance issues if underlying SQL query has performance issues.
How to Create Derived Tables
Derived tables are like database views the only difference is you can include @functions in a derived table.
You can include complex functions and calculations in a derived table these actions are performed before the result set is returned to the document.A Derived Table is a logical table created in Business Objects Universe using an SQL query. A derived table in a universe is analogous to a view created in database with a SELECT statement.
Disadvantages if derived table.
Since derived table is not an actual table you may face performance issues if underlying SQL query has performance issues.
How to Create Derived Tables
- From menu mar select Insert->Derived Tables
- Now write the SELECT statements which to define the structure of derived table. Remember to give Alias to column if you are using any expression in column list.
- Click on “Check Syntax” to confirm the definition of derived table
- Click OK