Creating Partitions

You can use the Partition Wizard to create additional partitions in a cube. You can specify which portion of a cube's data is allocated to a partition in two ways:

Assign the partition a fact table that is different from those used by the cube's other partitions
Filter data in a fact table used by multiple partitions

For more information, see Different Fact Tables for Partitions and Same 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.

Note You can create multiple partitions in a cube only if you install Analysis Services for Microsoft® SQL Server™ 2000 Enterprise Edition.

To start the Partition Wizard

Analysis Manager

Creating Partitions

See Also