Microsoft® SQL Server® 2008 Analysis Services Step by Step

Using the Aggregation Design Wizard

After you develop a measure group, you can use the Aggregation Design Wizard to design aggregations. A greater number of aggregations provides faster query response time, but uses more disk space and takes longer to process. So, when you use the Aggregation Design Wizard, you will be asked to restrict the number of aggregations that are designed by limiting the estimated amount of storage space the aggregations will use, by setting a limit for the performance gain the aggregations will provide, or by manually stopping the wizard while it is designing aggregations. The wizard, assuming that all queries are equally likely, will design the combination of aggregations that provide the best tradeoff between increased ...