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 Allow writeback of values 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]")