What is the definition of derived table ?
Answers were Sorted based on User's Feedback
Answer / subramanyam
Derived table is nothing but logical table like view.it
doesn't carry out any data in the database.It is the
function in the designer. You can use the view as the table
in the universe design and you can create the class objects
and conditions based on that derived table.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / kumarreddy
A derived table is one that is created on-the-fly using the
SELECT statement, and referenced just like a regular table
or view. Derived tables exist in memory and can only be
referenced by the outer SELECT in which they are created.
| Is This Answer Correct ? | 4 Yes | 0 No |
Explain how many universes can be created in a project?
can anybody tell me about issues faced while creating reports
1 Answers Accenture, Tech Mahindra,
how to link 3 fact tables
11.what are the features in BO?
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...
IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?
plz tell me about BOmain key in detail?
wha is the difference b/w merge dimension and combining two different data providers?
How to fix the order of Prompts? How to assign the default value in prompt?
What is the use of Surrogate key in BO?
Explain about a task that really tested your analytical abilities?
What are universe parameters?