WBC

Writes a value into an OLAP database. The value can be a number, a string or a cell reference. You must specify an element for each dimension of the referenced cube. WBC is commonly used in actions, to write values directly into a database.

Syntax

= WBC(value, "data_connection", "cube", "slice_element" {,"slice_element}")

You cannot write back a value in the cell containing the WBC function. Enter the values in an unprotected cell and reference that cell in the WBC formula.

The WBC function is commonly used in planning applications. Users are shown the current year’s figures and enter their forecast figures for the next year in an empty cell. The empty cell is referenced by a WBC formula on the worksheet and writes back the forecast values.

Note: You can use the WBC formula in an Edited cell action The changed value is written back when it is entered in the cell.

Example

Create a hyperblock in, for example, cells B9 to D9.
In one value cell, enter a formula to return actual figures for a year. In the other, enter an RWC formula to return the forecast figures for a subsequent year.
Remove cell protection from the forecast cell to make it writable.
Right-click the forecast cell and select Define Action.
Select Set parameters as the action type and Edited cell as the action mode.
In the Parameters section, click <Add parameter> and select No target.
Double-click the Value field to open the Edit value dialog. Specify the WBC formula with this syntax:
```
= WBC(value, "data_connection", "cube", "slice_element" {,"slice_element}")
```

Use the cell reference of the forecast cell as the value argument of the formula. For example:

=WBC(D9,"BestPracticesOLAP","Sales","[PROFIT].[Sales Volume]",
"[TIME].[All Years].[2010]","[VERSION].[Forecast]","[CURRTYPE].[LC]",
"[LEVEL].[IFRS]","[UNIT].[G0000]","[INTERCO].[TotalPartner]")

By combining the WBC function with the Edited cell action mode, you can change the values entered. For example, you could increase the values entered by 10% by editing the value argument to, for example, =WBC(D9*1.1,).

You could also allow users to enter only figures above a specified amount or within a certain range. Change the condition of the action from, for example, =TRUE to =D9>10000.