IF VIEW IS FASTER THAN DERIVED TABLE WHY WE ARE USING DERIVED TABLE IN BUSINESS OBJECTS?
Answer Posted / sahil
Although view is faster than derived table, but if we want
to filter out the data from select query of derived table
then we can use @prompt in derived table. but it cant be
done in views.
| Is This Answer Correct ? | 11 Yes | 5 No |
Post New Answer View All Answers
What are the steps to do to use alerts in bo?
BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...
How we drill up week to month?
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
Explain about a time when you discovered a more efficient way to do a work task?
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?
Explain is there any other repository domains rather than universe, security, document?
explain in detail about type 3?
What is a bo repository?
What is package in BO
What are the data types present in bo? What happens if we implement view in the designer and report?
Can anybody tell me what are the tuning problems?
Explain what is the difference between business requirement document and use case document.
What is a fantrap in business objects?
Explain what are the measure objects?