How to convert a cube's writeback data to a partition and write-disable the cube

To convert a cube's writeback data to a partition and write-disable the cube

1. In the Analysis Manager tree pane, under the database that contains the cube, expand the Cubes folder.
   
   
2. Right-click the cube, point to Writeback Options, and then click Convert to Partition.
   
   
3. In the Convert to Partition dialog box, in the Partition name box, type a name for the partition.
   
   
4. Select an aggregation design option:
   • To design aggregations using the Storage Design Wizard, click Design the aggregations for your partition now. For more information, see Designing Storage Options and Aggregations.
     
     
   • To defer aggregation design, click Design the aggregations later.
     
     
   • To copy the aggregation design of an existing partition, click Copy the aggregation design from an existing partition and select the partition name from the Copy from list. 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.
5. To specify a filter (WHERE clause expression) that limits the data selected from the writeback table and added to the partition, click Advanced. For more information, see Partition Filters and Incremental Update Filters.
   
   
6. To process the new partition, select the Process the partition when finished check box. Depending on the size of the writeback table, processing may take considerable time.

See Also

Converting Writeback Data to a Partition