HI, can anybody explain me how performence will decrease if
we create objects using derived tables ?
Answers were Sorted based on User's Feedback
Answer / manoj
Derived Tables decrease the performance because even if you
include one single object from this table the entire query
from the table is executed .
You can see this in the sql Query panel.
hence i would avoid using any derived tables unless
mandatory
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / ashok
by using derived table we can improve the query performance
because that is not created in database it can be designed
at universe designer only.
| Is This Answer Correct ? | 2 Yes | 2 No |
when I am trying to schedule the report its running faster then I tried to run it manually?? why is it so that there is difference of time between scheduling and manual run for report
What is the use of Surrogate key in BO?
Can any please explain FOR EACH AND FOR ALL?
How to view Public folder in Infoview for the Non-admin user? (normal user) What is the diff of working DEKI,WEBI in Infoview, and working as Individual start->Business Objects-> Deskto Intelligence, Web Intelligence.
How to hide objects or columns?
how many times can use the union operator in a report?
in report level u find from which context u use,why it appears,what is the reason,how u resolve in report level
What is meant by Adhoc reports?Can any body will explain with examples...Thanks in Advance .........prakash
how do u implement dense rank in a report?
2 table is there , thats column is different name but data type is same, 2 tables values are same. how to you findout both values are same?
what is merged imension in 6.5 and webi
how many micro cubes can a report can have