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. 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.

For more information about starting the Partition Wizard, see How to: Add or Delete a Partition.

See Also

Concepts

Managing Analysis Services Partitions
Partitions (Analysis Services)
Remote Partitions

Help and Information

Getting SQL Server 2005 Assistance