Partitions

Analysis Services

Analysis Services

Partitions

Partitions are used to store and manage precalculated aggregations and, sometimes, source data. They also offer flexibility in storing such data in multiple locations and in optimizing its access; they are also useful in managing the growth of cubes over time.

The following topics describe structural considerations for partitions.

Topic Description
Introduction to Partitions Describes basic characteristics of partitions and provides an example of a multiple-partition cube
Partition Structure Identifies requirements pertaining to the structure of partitions
Partition Storage Describes differences between the three storage modes
Indexed Views for ROLAP Partitions Identifies conditions necessary for Microsoft® SQL Server™ 2000 Analysis Services to create indexed views for aggregations
Remote Partitions Describes remote partitions and their restrictions
Incremental Updates and Partitions Identifies considerations relative to updating partitions incrementally