Partition Wizard F1 Help (SSAS)
You can use the Partition Wizard to define partitions for a measure group in a cube. By default, a single partition is defined for each measure group in a cube. Access and processing performance, however, can degrade for large partitions. By creating multiple partitions, each containing a portion of the data for a measure group, you can improve the access and processing performance for that measure group. For more information about partitions, see Partitions (Analysis Services). You can start Partition Wizard from Cube Designer in Business Intelligence Development Studio.
Warning
It is possible to create partitions that may contain incorrect data by including duplicate rows in the Specify Source Information or Restrict Rows pages. For more information, see Defining and Configuring a Partition.
The Partition Wizard guides you through the following steps:
- Selecting the data source view for the partition.
- Creating a filter for the records included in the partition.
- Setting the processing and storage locations.
- Naming and saving the partition.
In This Section
- Specify Source Information (Partition Wizard)
- Restrict Rows (Partition Wizard)
- Processing and Storage Locations (Partition Wizard)
- Completing the Wizard (Partition Wizard)
- Browse for Remote Folder Dialog Box (SSAS)
See Also
Reference
Analysis Services Wizards (SSAS)
Other Resources
Partitions (Analysis Services)
Defining and Configuring a Partition