Managing the Pool of Potential Aggregations
The Storage Design Wizard selects aggregations from a pool of potential aggregations. As a default, the pool of potential aggregations includes all levels from all dimensions. Analysis Services includes two techniques for controlling the pool of potential aggregations. One option is to use actual usage patterns to affect the rankings within the pool. Another option is to eliminate dimension levels from the pool entirely.
Preparing for Usage-Based Optimization
The algorithm in the Storage Design Wizard is sophisticated, but it can base its decisions solely upon structural factors such as the number of members in different levels of a dimension or the number of rows in a fact table. The Storage Design ...