Maintaining Write-Enabled Cubes and Writeback Data

Analysis Services

Analysis Services

Maintaining Write-Enabled Cubes and Writeback Data

If you write-enable a cube, end users can change displayed cube data while they browse it. However, the changes are saved in a separate table called a writeback table, not in the cube data or source data. End users who browse a write-enabled cube see the net effect of all changes in the writeback table for the cube.

On a write-enabled cube, you can use cube roles to grant read/write access to users and groups of users, and to limit access to specific cells or groups of cells in the cube. For more information about granting read/write access to a cube's cells, see Cell Security.

You can browse or delete writeback data. You can also convert writeback data to a partition.

The following table lists links to topics that provide more detailed information.

Topic Description
Write-Enabling a Cube Describes using the Write-Enable dialog box to write-enable a cube.
Browsing Writeback Data Describes using the Browse Data dialog box to browse data for a write-enabled cube.
Deleting Writeback Data and Write-Disabling a Cube Identifies considerations when deleting writeback data for a cube.
Converting Writeback Data to a Partition Identifies considerations when converting writeback data to a partition.

Note  Converting to a partition is available only if you install Analysis Services for Microsoft® SQL Server™ 2000 Enterprise Edition.

See Also

Write-Enabled Cubes