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.
See Actions.
Example
- Create a hyperblock in,
for example, cells B9 to D9.
See Hyperblocks.
- 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.
- Remove cell protection from the forecast cell to make it writable.
- Create a report variable.
- Right-click the forecast cell and select .
- Select Set parameters as the action type and Edited cell as the action mode.
- In the Parameters section, double-click <New Parameter> and select the variable from the list of report variables.
- 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")
- 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).