Jaa


Setting Dimension Writeback Capability

Add the dimension writeback enhancement to a cube or dimension to allow users to manually modify the dimension structure and members. Updates to a write-enabled dimension are recorded directly in the dimension table. This enhancement changes the WriteEnabled property setting for a dimension.

To add dimension writeback, you use the Business Intelligence Wizard, and select the Enable dimension writeback option on the Choose Enhancement page. This wizard then guides you through the steps of selecting a dimension to which you want to apply dimension writeback and setting this option for the selected dimension.

Selecting a Dimension

On the first Enable Dimension Writeback page of the wizard, you specify the dimension to which you want to apply dimension writeback. The dimension writeback enhancement added to this selected dimension will result in changes to the dimension. These changes will be inherited by all cubes that include the selected dimension.

Setting Dimension Writeback Capability

Oon the second Enable Dimension Writeback page of the wizard, you actually set the Enable writeback in the dimension option. Selecting this option automatically sets the WriteEnabled property of the dimension to True. Clearing this option automatically sets the property to False.

See Also

Concepts

Working with a Write-Enabled Dimension
Write-Enabled Dimensions

Help and Information

Getting SQL Server 2005 Assistance