RWC
This function returns a cell value from an OLAP cube and writes back changes.
Note: ROC is the non-writable version
of RWC. To disable write back in a cell values formula, change RWC to ROC or
clear the option in the Edit OLAP
Formula dialog.
Syntax
You must specify a value for all dimensions in the selected cube. The order of the dimensions is also important. For these reasons, we recommend that you use the Edit OLAP Formula wizard to create and edit ROC and RWC formulas.
=RWC("data_connection", "cube", "slice_element
{,"slice_element}")
Example
=RWC("BestPracticesOLAP","SALES","[CURRTYPE].[LC]","[INTERCO].[TotalPartner]",
"[LEVEL].[IFRS]","[PRODUCT].[All Tires]","[PROFIT].[Sales Volume]","[TIME].[YTD]","[UNIT].[G0000]",
"[VERSION].[Actual]")