why u go for aggregate? tell me one example?
- 5 Answers
- 16230 Views
- Accenture, HP, TCS, I also Faced
- E-Mail Answers
Answer Posted / vinod
to improve performence aggregates r used the main use of
aggregates are
1) when infoobject data is used repeatedley
2) when master data do not change much
3) to improve the performance in reporting
4) aggregates acts like indexes
demerites :-
1) denormilisation of data in cube and aggregates
if u cube contains infoobject object country we can create
fixed aggregate on country
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What are the inputs for an infoset?
What are the do?s and don?ts?
What are the tools to monitor overall query performance.
How do I send really complex mails from the workflow?
When is idoc data transfer used?
What is extraction setup?
When i am executing process chain ,the pc takes data into the xml file and transfer to the next process..where this xml file is stored?
what is virtual kef figures? what are the uses and in which case supposed to be use?
How do you do Currency translation in SAP BW ?What are the settings that needs to be done?
How to get the recordmode D or A in changelog table when we delete or add records in DSO?
what is sid for to trasport the object along the land scape:/
What is the dimension in bw?
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 are the monitor settings?
What are the parameters available in user exit for enhancing master data?
