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 configure two instances of CMS pointing to two different CMS system databases?
What is package in BO
What is the difference in creating filters in designer and business objects?
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
How would you format some text using css to be verdana and bold?
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
What is difference between webi and infoview?
What are the steps to be taken to schedule the report?
what are the day to day activities of BO administrator ?
Explain in detail about type 1?
how to create metric universe ?
What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?
Explain the difference between detect alias and detect context?
What is Indexing? how did u implement indexing?
Explain is there any default username & pwd for bo designer & supervisor?