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. |
|
Assign a named query to the partition that is different from those used by other partitions of the measure group. |
|
Filter data in a fact table (or named query) used by 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.