Why derived tables in business objects

You are commenting using your Twitter account. You are commenting using your Facebook account. Notify me of new comments via email. Notify me of new posts via email. This site uses Akismet to reduce spam. Learn how your comment data is processed. Like this: Like Loading Related posts. Leave a Reply Cancel reply Enter your comment here Fill in your details below or click an icon to log in:.

Email required Address never made public. They are used to reduce maintenance of database summary fields. Instead of using aggregate tables in Universe, you can use derived tables to return same data. This will open Derived table dialog box. You need to enter Derived table name and SQL query to select data in derived table. You can also make use of tables and columns along with Operators and Functions to create expression for derived table.

The derived table appears in the schema with the physical database tables and you can build the objects on derived tables. Marketing Advertising Analytics Email. Contact [email protected] Privacy Policy Status. Creating a derived table to return server information. Showing the number of regions in each country. Derived tables have the following advantages: Reduced amount of data returned to the document for analysis. Reduced maintenance of database summary tables. Business Object - Universe Designer.

You do this as follows: Select Derived Tables on the Insert menu. The Derived Tables dialog box appears.