Convert to Partition Dialog Box

Enables you to convert a write-back table to a partition. This action also disables read/write permissions on the cube and deletes the data in the write-back table. (Users with disabled 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 Partitions.


This dialog box appears when you right-click a cube, point to Write-Back Options, and then click Convert to Partition.

Options

Partition name

Type a name for the new partition.

Design the aggregations for your partition now

Select this option to start the Storage Design wizard when you click OK.

Design the aggregations later

Select this option to save the partition when you click OK but design aggregations later.

Copy the aggregation design from an existing partition

Select this option to 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

Select this option to process the new partition when you click OK. This option is not available if you selected Design the aggregations for your partition now.

Advanced

Click Advanced to add a filter or to change the aggregation prefix. The Advanced Settings dialog box is displayed. For more information, click Help in the Advanced Settings dialog box.

OK

Saves changes you have made, converts the write-back table to a partition, and closes the dialog box.

Cancel

Closes the dialog box without saving changes.

Help

Displays this topic in online Help.

(c) 1988-1998 Microsoft Corporation. All Rights Reserved.