Answer Posted / 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 |
Post New Answer View All Answers
What is a view as it relates to system modeling?
What does level of granularity of a fact table signify?
Explain the process of extracting data from source systems,storing in ods and how data modeling is done?
What is incremintal loading?
What is type 2 version dimension?
What is a relationship?
Explain me what are conformed dimensions?
What are the advantages of query studio compared to report studio?
Explain the versions of reportnet?
What is the main difference between schema in rdbms and schemas in datawarehouse?
Database in use is oracle?
What is aggregate fact table?
Why should you put your data warehouse on a different system than your oltp system?
Explain dimensional modelling?
How can we load the time dimension?
