Converting Writeback Data to a Partition
You can convert the data in a cube's writeback table to a partition.
Caution Incorrect use of partitions can result in inaccurate cube data. For more information, see Managing Partitions.
When you convert the writeback data for a cube to a partition, you also write-disable the cube. All Unrestricted Read/Write policies and read/write permissions for the cube's cells are disabled, and end users will not be able to change displayed cube data. (End users with disabled Unrestricted Read/Write policies or disabled read/write permissions will still be able to browse the cube.) Read and read contingent permissions are not affected.
This procedure causes the writeback table to become the new partition's fact table.
Note Converting to a partition is available only if you install Analysis Services for Microsoft® SQL Server™ 2000 Enterprise Edition.
To convert writeback data to a partition, use the Convert to Partition dialog box, which is accessed by right-clicking a write-enabled cube from the Analysis Manager tree pane.
To convert a cube's writeback data to a partition and write-disable the cube