HI, Can any body explain me ? If we careate objects using
derived tables it will decreasess the performence? If we
are not creating the objects using the derived tables then
what is the use of having the derived tables?
Answer Posted / gowthami
In some scenario’s we cannot meet the requirement. In that case using derived table we can create own query with needed objects and can write the formula to achieve the requirement which cannot be done in general.
If there is no other way to achieve the requirement only the derived table can do. We can go for derived table. But it will decrease the performance of universe (more no of derived tables)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to execute the plsql procedure from the report by clicking with mouse?
Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?
When we use aggregate awareness function in designer?
Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?
Explain what is the difference between business requirement document and use case document.
What Is Snow Flake Schema?
What are the steps to be taken to schedule the report?
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
What is difference between webi and infoview?
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
Explain how to schedule the report in b.o?
what is document design in boxi,have u participate in that
What is report template in b.o?
What are the data types present in bo? What happens if we implement view in the designer and report?
What are the steps to do to use alerts in bo?