Write-Enabling a Cube

If you write-enable a cube, users in roles that are granted read/write permission to the cube can record changes to cube data while they browse the cube. Changes are recorded in the write-back table, separate from the cube data and its source data. Users who browse a write-enabled cube see the net effect of all changes in the write-back table for the cube.

For more information about roles and read/write permission, see Creating Security Roles.

To write-enable a cube, use the Write-Enable dialog box.

To write-enable a cube

1. In the OLAP Manager tree view, under a database, expand the Cubes folder.
2. Right-click the cube, and then click Write-Enable.
3. In the Write-Enable dialog box, in the Table name box, type a name for the write-back table.
4. In the Data source box, select a data source name.

   To specify a new data source, click New. In the Data Link Properties dialog box, specify the new data source, and then click OK. For more information, see Specifying Data Sources.

5. In the Write-Enable dialog box, click OK.