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