Chapter 13. Designing Aggregations

In this chapter, you will learn how to:

  • Design aggregations using the Aggregation Design Wizard.

  • Improve aggregation design by creating attribute relationships and user-defined hierarchies.

  • Control the aggregation of an attribute using the AggregationUsage property.

  • Design an individual aggregation.

  • Improve aggregation design by using long-term estimates of data volume.

  • Enable Analysis Services query logging.

  • Design aggregations based on logged queries using the Usage-Based Optimization Wizard.

In Chapter 2, you learned that Analysis Services provides two major benefits: sophisticated data analysis capabilities and fast query response. In subsequent chapters, you learned how to create an Analysis Services database that ...

Get Microsoft® SQL Server® 2008 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.