Designing Partition Storage and Aggregations

You can design storage for a cube on the Partitions tab in Cube Designer. You can configure storage and design aggregations separately for each partition in a measure group. You can also set default storage settings for any measure group.

Note

For more information about query and performance issues related to partitions and aggregations for Analysis Services, see the sections “Enhancing Query Performance” and “Tuning Processing Performance” in the SQL S erver 2005 Analysis Services Performance Guide.

Topic Description

Configuring Storage

Describes how to configure storage for a partition.

Designing Aggregations (SSAS)

Describes how to design aggregations for a partition.

Choosing a Standard Storage Setting

Describes storage configurations for storage modes and caching options.

Setting Custom Storage Settings

Describes the custom proactive caching and storage settings available.

See Also

Concepts

Managing Analysis Services Partitions

Help and Information

Getting SQL Server 2005 Assistance