Share via

  • Article

Creating and Managing Local Partitions

You can use the Partition Wizard to create additional partitions in a cube. The Partition Wizard is opened by first expanding a measure group entry on the Partitions tab in Cube Designer and then clicking New Partition.

Note

For more information about performance issues related to cube design, see the SQL Server 2005 Analysis Services Performance Guide.

For the different ways to allocate data from a measure group to a partition, see the following table.

Task

Topic

Assign a fact table to the partition that is different from those used by other partitions of the measure group.

Different Fact Tables for Partitions

Assign a named query to the partition that is different from those used by other partitions of the measure group.

Different Named Queries for Partitions

Filter data in a fact table (or named query) used by multiple partitions.

Filtering a Fact Table for Multiple Partitions

Regardless of the method you use to specify the data for a partition, you must ensure that data is not duplicated among a cube's partitions.