main purpose of aggregate awareness(not include make
possible of use of aggregate tables)
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / sonia
Aggregate Awareness is used to avoid having an object
multiple times, in different classes, for the fact table
and the aggregated table.
Is This Answer Correct ? | 1 Yes | 8 No |
Is it possible to generate reports without having knowledge of the Universe structure?
How to get top 5 rows of a selected column?
What is a category?
how do u implement dense rank in bo reports?
How to create a report template BO XI R2
what are they different types of report in BO?
What is global filters and local filters
How to link two different universes ?
why do we use crystal reports rather than webintelligence reports ?
What is aggregate table and aggregate fact table ... Any examples of both?
Is it possible to create a new calendar using BO? Ex:- Wants to create a calendar where the year starts with the 1feb - 25Feb. Next month from 26Feb - 14Mar.
what is merged imension in 6.5 and webi