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.
Warning
If you use SQL Azure as a data source to perform writeback into an Analysis Services database, the operation fails. This is by design, because use of multiple active result sets (MARS) is not turned on by default.
The workaround is to add the following setting in the connection string, to support MARS and to enable writeback:
"MultipleActiveResultSets=True"
For more information see Using Multiple Active Result Sets (MARS).