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
In banking domain how many Fact tables,Dimension table are present?
Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
Explain the difference between detect alias and detect context?
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?
In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha
Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
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?
How to sort the dynamic objects alphabetically on the Universe based on and SQL Server
How many universes can be created in a project?
What is Indexing? how did u implement indexing?
Can anybody tell me what are the tuning problems?
Explain what is aggregate table and aggregate fact table ... Any examples of both?
Explain what sort of existing documents should business analysts refer to when starting on a new project?
Explain when we use aggregate awareness function in designer?