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?
- 3 Answers
- 3945 Views
- I also Faced
- E-Mail Answers
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 get the grand total in master-detail report?
Explain what sort of existing documents should business analysts refer to when starting on a new project?
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
Which command using Query Analyzer will give you the version of SQL server and operating system ?
Did you face any problems while creating reports? Name? Solutions?
What is the difference between absolute and relative div positioning?
What is the difference between business requirement document and use case document.
Explain is there any default username & pwd for bo designer & supervisor?
Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com
What is the difference between condition & filter?
How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
How would you format some text using css to be verdana and bold?
what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?
What is top business?
