RWC

Gets a cell value from an OLAP Server 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.

See ROC.

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.

See Creating and editing ROC and RWC formulas.

If you use an Infor CPM Relational Provider database alias and you migrate from the DS Connector driver to XMLA, the order of the dimensions can change and RWC formulas cease to work.

See Infor CPM Relational Provider.

=RWC( "database alias", "cube", "slice element dimension 1", ..., "slice element dimension N")

Example

=RWC("Best Practices OLAP","SALES","[CURRTYPE].[LC]","[INTERCO].[TotalPartner]",
"[LEVEL].[IFRS]","[PRODUCT].[All Tires]","[PROFIT].[Sales Volume]","[TIME].[YTD]","[UNIT].[G0000]",
"[VERSION].[Actual]")