What is a derived table in data warehousing?
Answers were Sorted based on User's Feedback
Using SQL queries in the database level, Derived tables are created in the universe.
The column of the derived tables will be the column selected in the query. Derived tables
Is used to complex calculations which are difficult to be achieved in the report levels. Using DB link,
Tables can be accessed from a different schema, is another use of different schema.
Is This Answer Correct ? | 0 Yes | 0 No |
Derived tables are like Views in the Database level.It uses the complex calculations from different tables and maintained in a single table.But it will affect the performance.
Is This Answer Correct ? | 0 Yes | 0 No |
How to access one derived table from another? : sap bobi
How do I create a universe?
Explain personal, shared and secured? : sap bobi
Define custom hierarchies?
Why webi is called as a business user tool as well as a designer tool at the same time?
What is designer? : bo designer
Define Designer?
How auditing in BI 4.0 works?
Define WEBI?
Explain shared connection?
How can Chasm Trap be solved?
How do you define universe parameters? : sap bobi