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 hybrid slowly changing dimension?
What are the steps of implementing data warehousing?
Explain the main differences between star and snowflake schema?
What are the different problems that ?Data mining? can solve?
What is called dimensional modelling?
I know of using applysimple, but there are other ways too?
what are different storage options supported by oracle ?
does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com
Explain what is power center repository?
Explain about core dimension,
Explain what are data marts?
What is the difference between snowflake and star schema?
What is incremintal loading?
Explain what are the advantages and disadvantages of reporting directly against the database?
What is the use of tabular model, tabular sql, tabular reference in real time application?