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 ...

Get Microsoft® SQL Server™ 2000 Analysis Services Step by Step now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.