why u go for aggregate? tell me one example?
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 is the licensing requirement you should be aware of?
How does the time dependency works for bw objects ?
what are the different components in dso architecture?
What is an infocube?
Do you have any idea how to improve the performance of the bw?
You have 3 cube for which you create multiprovider and a report. The data doesn't show up in the report. What went wrong?
What is rowlevel security ? can u please explain with real time example?
Which datastore object is used?
How do you do Currency translation in SAP BW ?What are the settings that needs to be done?
When you fill in the values for selection, what are the options available in general?
Explain tickets?
What are the mathematical functions?
How do you add an entry in the monitor log from the update rules?
what is InfoCube?what are the types and uses and in which Case it suppose to be use?
You want to see if the execution of a query has been slow or fast. How would you do that?