Enable writeback
Click the
icon on your ad-hoc analysis toolbar and select the 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, the
and options are available in the properties of your ad-hoc analysis toolbar. Alternatively, right-click the data cell value and select 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.