Writing back values

Report cells can be made writable so that users can enter or change values in the database.

Two pairs of functions can be used to make cells writable: RWC/WBC write back values and RWA/WBA write back attributes.

Use RWC (Read Write Cell) formulas to retrieve values from the database and enable users to update and save them.

Use WBC (Write Back Cell) formulas where there is no existing value in the database, but users need to be able to enter values. It provides a blank cell for data entry. We recommend that you use WBC and WBA formulas within actions using the Edited Cell action mode.

RWC formulas can be created in the Edit OLAP Formula dialog. Select Cell values as the formula type and select the Fixed mode and Allow writeback check boxes.

If you specify RWC or WBC formulas manually, you must also manually remove write protection from the cell. Right-click the cell and select Format Cells. On the Protection tab, clear the Cells check box.

You can write back directly to base elements but not to consolidated elements. For example, you could change the value of an individual product element but not the value of an ’All Products’ element.

When you write back a value to a base element, the values of any consolidated elements that reference the base element are recalculated. For example, January, February and March can be defined as base elements of the 1st Quarter consolidated element. If you write back a value to January, the value for the 1st Quarter is updated.

Note: When writing back strings (for example, attributes) you may need to include reference numbers as part of the string. To force numbers to be written as strings, prefix them with an apostrophe. For example, 007 writes back 7 but '007 writes back 007.