What is an aggregate?
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
run,space,etc.
Is This Answer Correct ? | 4 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 function module to convert currency?
What are the enhancements one can do in SAP MM,PP,SD, modules while extracting the data?
What are the size parameters for archiving?
What is compounding?
Can you create aggregate on ODS or multi provider?
In update rules for an infocube we can specify separate update rules for characteristics of each of the key figures. In which situations is the above used?
What do you mean by the term rollup in the sap bw?
List the steps to do the converting from lis to lo extraction.
What is the use of db connection in sap bw data acquisition?
What is the grouping option available when installing?
why ods activation fail? What types of fails are there? What are the steps to handle
We have standard info objects given in sap why you created zinfo objects can u tell me the business scenario