Finish (Partition Wizard)
In this step of the wizard, you can name your partition, choose aggregation design options, and specify advanced settings for your partition. You can also process your new partition when the wizard finishes.
Caution It is possible to create partitioned cubes that contain incorrect data. For more information, see Managing Partitions.
If in an earlier step you selected the default fact table (that is, the same fact table used by the cube), you must use a filter to ensure that each partition in the cube includes mutually exclusive data. Otherwise, the cube containing the partition will contain duplicate and therefore inaccurate data. To create a filter, click Advanced.
Options
Partition Name
Type a name that is unique in the database. You can enter a maximum of 50 characters.
Design the aggregations for your partition now
Select to start the Storage Design Wizard when you click Finish.
Design the aggregations later
Select to save your partition now and design aggregations later.
Copy the aggregation design from an existing partition.
Select to copy the aggregation design from another partition to your new partition.
- Copy from
Select the partition from which to copy the aggregation design.
Note If in the future you might merge the new partition with another, copy the aggregation design of the other partition. To be merged, partitions must have the same structure and aggregation design.
Process the partition when finished
Select if you want to process the new partition when you click Finish. This option is not available if you select Design the aggregations for your partition now.
Advanced
Click to display the Advanced Settings dialog box, where you can add a filter (WHERE clause expression), change the aggregation prefix, or specify drillthrough options.
Finish
Click to apply the settings you have chosen and either save the partition, process and then save the partition, or start the Storage Design Wizard.