Answers were Sorted based on User's Feedback
Answer / pavan
Aggregate is the baby cube of infocube,for execution of
reports,the data would be taken from 'F' table of aggregate.
|Is This Answer Correct ?||5 Yes||0 No|
Answer / shirisha
When few of the characteristics and key figures are
frequently accessed, then an aggregate is created by
selecting those characteristics and key figures from the
parent Info Cube. Aggregates reduce the extraction time but
involves other overheads like attribute change
|Is This Answer Correct ?||4 Yes||0 No|
Answer / siva
It is a subset on a info cube
|Is This Answer Correct ?||3 Yes||0 No|
Answer / mohan
when my query hits same characterstics and keyfigures daily to reduce the query time i made an aggregate with that particular info objects..
Adv is improve the query performance.
disadv is it takes extra space for same data.so if your customer accepts then you create aggregates or else if it satisfy Thumb rules.
|Is This Answer Correct ?||1 Yes||0 No|
What is the importance of 'start routine' in update rules?
What is a dashboard in sap bw?
WHAT IS THE DIFFERENCE BETWEEN WORKBENCH REQUEST AND CUSTOMERIZIED REQUEST
If you are asked to change the way tables are displayed in web reporting how would you do this?
What all data sources you have used to acquire data in sap bw system?
what is high cardinality tell me brief
what is re-partioning and re-modeling in bi 7.0 and what are the uses and in which case supposed to be use?
What is the number of decimal places in scaling factor?
What is the program to maintain change run?
What is a template?
what are the benefits of cubes?
What are the project phases within ASAP?