Derived Tables

How a derived table is useful than a view in database? What are the additional features derived table provides?

Questions by Honed

Showing Answers 1 - 2 of 2 Answers


  • May 21st, 2010

Derived tables are tables that you define in the universe schema. You create objects on them as you do with any other table. A derived table is defined by an SQL query at the universe level that can be used as a logical table in Designer.

Derived tables have the following advantages:

• Reduced amout of data returned to the document for analysis.
You can include complex calculations and functions in a derived table. These operations are performed before the result set is returned to a document, which saves time and reduces the need for complex analysis of large amounts of data at the report level.

• Reduced maintenance of database summary tables.
Derived tables can, in some cases, replace statistical tables that hold results for complex calculations that are incorporated into the universe using aggregate awareness. These aggregrate tables are costly to maintain and refresh frequently. Derived tables can return the same data and provide real time data analysis.

Derived tables are similar to database views, with the advantage that the SQL for a derived table can include BusinessObjects prompts.

Derived table are created at the universe level.

1. They are usually created to fetch results from tables using a complex
logic condition.
2. To get the Max/ Min date for the data set. Usually used to find the Latest
Data date or Oldest data date etc.
3. Its not a good idea to uses them to aggregate data

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions