Aggregation Design Wizard F1 Help (SSAS)
Aggregations provide performance improvements by allowing Microsoft SQL Server 2005 Analysis Services (SSAS) to retrieve pre-calculated totals directly from cube storage instead of having to recalculate data from an underlying data source for each query.
To design these aggregations, you can use the Aggregation Design Wizard. This wizard guides you through the following steps:
- Selecting standard or custom settings for the storage and caching options of a partition, measure group, or cube.
- Providing estimated or actual counts for objects referenced by the partition, measure group, or cube.
- Specifying aggregation options and limits to optimize the storage and query performance delivered by designed aggregations.
- Saving and optionally processing the partition, measure group, or cube to generate the defined aggregations.
After you use the Aggregation Design Wizard, you can use the Usage-Based Optimization Wizard to design aggregations based on the usage patterns of the business users and client applications that query the cube.
In This Section
- Select Partitions to Modify (Aggregation Design Wizard) (SSAS)
- Specify Storage and Caching Options (Aggregation Design Wizard) (SSAS)
- Specify Object Counts (Aggregation Design Wizard) (SSAS)
- Set Aggregation Options (Aggregation Design Wizard) (SSAS)
- Completing the Wizard (Aggregation Design Wizard) (SSAS)
See Also
Reference
Usage-Based Optimization Wizard F1 Help (SSAS)
Analysis Services Wizards (SSAS)
Other Resources
Aggregations and Aggregation Designs (SSAS)
Defining and Configuring Cubes and Cube Properties