Microsoft® SQL Server® 2008 Analysis Services Step by Step

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