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
Explain conformed fact?
How to drill through from a powerplay cube to reportnet?
What are the other names given to data warehousing?
After the complete generation of a report who will test the report and who will analyze it?
Start a batches with in a batch?
Suggest a good author for hyperion in data warehousing?
Explain dimensional modelling?
Can decision tree be implemented using SQL?
Can you pass sql queries in filter transformation?
Explain meta data?
Explain the definition of normalized and denormalized view and what are the differences between them?
Explain what is type 2 version dimension?
Name a few sectors which use data warehousing?
What is the purpose of cluster analysis in data warehousing?
Explain what is data validation strategies for data mart validation after loading process?