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 are the types of SCD?
what is a hot file, why we need in datawarehousing, where we used in general
How to export mappings to the production environment?
what is the difference between MOLAP and ROLAP?
how much memory space occupied real time project (roughly)?
How many project sources we can create in metadata?
Do you view contain data?
Can we start and stop single session in concurent bstch?
In microstrategy, how can we direct the sql generated to use a specifc table?
Disply the dname wise maximum salary
What is difference between query studio and report studio?
What is the difference between star and snowflake schemas?