WBC

Writes a value into a cell. The value can be a number, a string or a cell reference.

Syntax

= WBC(value, "database alias", "cube", "slice element dimension1","slice
		element dimension2")
	 

You cannot writeback 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 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 will then be written back when it is entered in the cell.

See Actions.

Example

  1. Create a hyperblock in, for example, cells B9 to D9.

    See Hyperblocks.

  2. In one value cell, enter an ROC (ROC) formula to return actual figures for a year. In the other, enter another ROC formula to return the forecast figures for a subsequent year.
  3. Remove cell protection from the forecast cell to make it writable.
  4. Create a report variable.

    See Creating report variables.

  5. Right-click the forecast cell and select Define Action.
  6. Select Set parameters as the action type and Edited cell as the action mode.
  7. In the Parameters section, double-click <New Parameter> and select the variable from the list of report variables.
  8. Double-click the Value field to open the Edit value dialog. Enter the WBC formula with this syntax:
    = WBC(value, "database alias", "cube", "slice element dimension1",
    "slice	element dimension2")
    	 
    	 
  9. Use the cell reference of the forecast cell as the value argument of the formula. For example:
    =WBC(D9,"Best Practices OLAP","Sales","[PROFIT].[Sales Volume]",
    "[TIME].[All Years].[2010]","[VERSION].[Forecast]","[CURRTYPE].[LC]",
    "[LEVEL].[IFRS]","[UNIT].[G0000]","[INTERCO].[TotalPartner]")

With the WBC function, you can change the values entered. For example, you could increase the values entered by 10% by editing the value argument (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 (for example, from =TRUE to =D9>10000).