SQL Server 2008 Books Online (October 2009)
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.

ms175611.note(en-us,SQL.100).gifNote:
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.

See Also

Concepts

Managing Analysis Services Partitions

Other Resources

Partitions (Analysis Services - Multidimensional Data)
Remote Partitions

Help and Information

Getting SQL Server 2008 Assistance
Tags :


Page view tracker