O'Reilly logo

Microsoft® SQL Server® 2008 Analysis Services Step by Step by Scott Cameron

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required