What is aggregate awareness?
Answers were Sorted based on User's Feedback
Answer / guest
aggregate awareness is a function in business objects with
which we can get information from the aggregate tables in
data base
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / learner
Aggregate awreness is the function in BO, which helps in
improving the performance of reporting. For ex. if we have
data at different levels of aggregation in different tables
of a single universe, then this function helps the bo to
select the table(detail table or light aggregated table or
highly aggregated table)(ex year, month,daily revenues in 3
tables) for running the query while creating the report
based on the grain level of reporting requirement.(for
example if we ask year wise revenue then it will directly
go to that year table instead of calculating it from the
daily table).
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the difference between a W/H and an OLTP application?
How many ways we test the universe & Report?
what role views play in dimensional modeling?
How can we acheive correlated sub-query in designer?can anyone help me in this regard?
What is perform recovery?
What is META DATA information in Data warehousing projects?
The same tier?
What is the difference between datawarehouse and bi?
What are the different models used in cluster analysis?
Code the tables statement to produce a multi-level frequency?
What is drilling across?
Explain what is a three tier data warehouse?