Designing Partition Storage and Aggregations

SQL Server 2008 R2

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.

NoteNote

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 Server 2005 Analysis Services Performance Guide.

Topic

Description

Configuring Storage

Describes how to configure storage for a partition.

Designing Aggregations

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.

Community Additions

ADD
Show: