Partition Wizard

Partition Wizard

Use this wizard to separate one logical cube into separate physical partitions. This allows you to 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 Managing Partitions.

The Partition Wizard appears when you expand your cube in the Analysis Manager tree pane, 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.
  
  
• (Optional.) Select a data slice (that is, subset of cube data) to be stored in the partition.
  
  
• Specify the partition type: local or remote.
  
  
• 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.
    
    
  • (Optional.) Process your partition.

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