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
what is universe null
What is the dense rank?
How to generate the report from excel sheet?
Explain when we use aggregate awareness function in designer?
What is the difference between user and versatile user?
Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
What is a bo repository?
What is difference between custom hierarchy and report based hierarchy?
Explain when to use local filter and when to use global filter?
Can we configure two instances of CMS pointing to two different CMS system databases?
What we need to discuss with designer before starting the universe designing.
How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)
Explain what is aggregate table and aggregate fact table ... Any examples of both?
webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??