Welcome Sign in
SQL Server Developer Center
Click to Rate and Give Feedback
Community Content
In this section
Statistics Annotations (0)
Other versions are also available for the following:
SQL Server 2008 Books Online (December 2008)
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.

Tags What's this?: Add a tag
Community Content   What is Community Content?
Add new content RSS  Annotations
© 2009 Microsoft Corporation. All rights reserved. Terms of Use  |  Trademarks  |  Privacy Statement
Page view tracker