Partition Wizard

Helps you separate one logical cube into separate physical partitions so that you can enhance flexibility in data storage and location of data sources and improve query performance. The wizard also helps you add partitions to cubes.

Caution It is possible to create partitioned cubes that contain incorrect data. For more information, see Partitions and its subtopics in the Administrator’s Guide.

Note User-defined partitions are available only if you install Microsoft® SQL Server™ OLAP Services, Enterprise Edition.

The Partition wizard appears when you expand your cube in the OLAP Manager tree view, right-click the Partitions folder, and then click New Partition.

The Partition wizard has the following steps:

• Specify the data source and fact table for the partition.
• Select a data slice, or subset of cube data, to be stored in the partition (optional).
• Final step:
  • Name your partition.
  • Specify filters (WHERE clause expressions) and/or set the aggregation prefix.
  • Start the Storage Design wizard to design your partition’s aggregations (optional) or copy the aggregation design of another partition.
  • Save your partition.
  • Process your partition (optional).