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
please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.
In banking domain how many Fact tables,Dimension table are present?
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
Can anybody tell me what are the tuning problems?
What is the profile and package?
Can we create universe with no cache??
Explain is there any other repository domains rather than universe, security, document?
is it possible to export the webi reports to crystal reports?with out using businessview?
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
How to sort the dynamic objects alphabetically on the Universe based on and SQL Server
What are the steps to be taken to schedule the report?
What is difference between custom hierarchy and report based hierarchy?
Difference between zabo and webi?
What is the difference in creating filters in designer and business objects?
Explain what is aggregate table and aggregate fact table ... Any examples of both?