main purpose of aggregate awareness(not include make
possible of use of aggregate tables)
Answer Posted / sai
Aggregate tables are used in the schema in oreder to
inprove the query performance.it is implemented by using
@aggregate_aware()function.these tables carries
precalculated aggregates(measures).it will improve query
performane,so we will get data fastly.refer this link to
know more:
http://www.dwoptimize.com/2007/09/aggregate-awareness.html
| Is This Answer Correct ? | 16 Yes | 0 No |
Post New Answer View All Answers
Hi, I would like to know how is the integration if we want to use Oracle Essbase as the Cube Engine, and present the Cube by Business Objects Presentation Layer? Can Oracle Essbase be integrated with Business Objects? Thanks,
how to create metric universe ?
Explain what would you consider as your biggest achievement and why?
Can anybody tell me what are the tuning problems?
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....
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
What three things do you consider to be the most important factors for a manager?
what are the day to day activities of BO administrator ?
How to schedule the report in b.o?
Can we Save (save as) WEBI Doc as DESKI?
What is the difference between user and versatile user?
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?
Which command using Query Analyzer will give you the version of SQL server and operating system ?
Explain what sort of existing documents should business analysts refer to when starting on a new project?