Database Reference
In-Depth Information
Adding
aggregations
to
improve
performance
The need for aggregations gets even more important when you start looking at larger
dimensions and larger datasets.
Then why not create aggregations on all levels of all dimensions? The problem with
this strategy would be both increased storage costs as well as the time the processing
would take. What you need to ensure is that you have the right number of aggrega-
tions on the levels that your users most often browse.
Aggregations are part of the cube and are created for each measure group on the
partition level. To create aggregations, you navigate to the
Aggregations
tab in the
cube designer.
You can either create aggregations manually by switching to the advanced view of the
aggregation designer, or you can get help by using the aggregation wizard.
Search WWH ::
Custom Search