how do u deceided to go create Aggregates for cube. what
purpose u want to create aggregates?
- 2 Answers
- 11059 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / vivek
you can check it from RSDDSTAT_OLAP table that which query
is being used mostly, and wht is the performance on that
basis you will create the aggregates on the cubes.
Aggregates are the small cubes through which the data
extraction is faster
| Is This Answer Correct ? | 12 Yes | 3 No |
Post New Answer View All Answers
When you are using sap bi7.x, you can load the data to which component?
What is a SID table and advantages?
What is the data flow from LIS tables to BW?
What are the naming conventions for aggregates created from statistics?
How do you check the alert monitor?
what are the reports used from business content in sap bw project?name them and what was the requirement?
When is idoc data transfer used?
How would you convert an info package group to a process chain?
What is the dimension in bw? How would you optimize the dimensions?
What is a repair request?
What is the dimension in bw?
What are the steps to load non cumulative cube?
What are nodes?
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?
In real world when do you recommend aggregate?
