Export (0) Print
Expand All
Expand Minimize

Convert to Partition Dialog Box

SQL Server 2000

Convert to Partition Dialog Box

Use this dialog box to convert a writeback table to a partition. This action also makes read/write permissions on the cube unavailable. (Users with unavailable read/write permissions can still browse the cube.) Read permissions are not affected.

Caution  It is possible to create partitioned cubes that contain incorrect data. For more information, see Managing Partitions.

This dialog box appears when you right-click a cube that has writeback enabled, point to Writeback Options, and then click Convert to Partition.


Partition name

Type a name for the new partition.

Design the aggregations for your partition now

Start the Storage Design Wizard when you click OK.

Design the aggregations later

Save the partition when you click OK, but design aggregations later.

Copy the aggregation design from an existing partition

Copy the aggregation design from another partition to the new partition. In the Copy from box, select the partition from which to copy existing aggregations.

If in the future you might merge the new partition with another, copy the aggregation design of the other partition. Merged partitions must have the same aggregation design.

Process the partition when finished

Process the new partition when you click OK. This option is not available if you select Design the aggregations for your partition now.


Use to add a filter, to change the aggregation prefix, or to specify drillthrough options. The Advanced Settings dialog box is displayed. For more information, see Advanced Settings Dialog Box.


Save changes you have made, convert the writeback table to a partition, and close the dialog box.

© 2014 Microsoft