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
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
U r project in which stage in implementation?
Can more than 1 metric be applied on an analytic in business objects?
explain in detail about type 3?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
What is the functional & architectural differences between business objects and web intelligence reports?
What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?
What are the data types present in bo? What happens if we implement view in the designer and report?
Explain which versions are used in the bo dashboard work?
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
how many reports have u created ? explain a few.
How to generate the report from excel sheet?
How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)
Explain the difference between union and group?
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?