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
Can we create universe with no cache??
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
Difference between b.o 5.1 and 6.1b?
What is object stores?
Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?
What is the functional & architectural differences between business objects and web intelligence reports?
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
what is document design in boxi,have u participate in that
Can more than 1 metric be applied on an analytic in business objects?
In banking domain how many Fact tables,Dimension table are present?
What is a bo repository?
Explain is data mart?
Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?
What is the difference in creating filters in designer and business objects?