Enable writeback

Click the Properties icon on your ad-hoc analysis toolbar and select the Enable Writeback check box to change or enter values to the database. To be able to write back values to data cells, the cube must be configured as writable in the Data Configuration dashboard.

After you enable writeback, theAdd row and Edit attributes options are available in the properties of your ad-hoc analysis toolbar. Alternatively, right-click the data cell value and select Replace Values to distribute values.

Replacing values is similar to writeback, but you can decide how to distribute values in a report according to a variety of rules.