ROC

ROC gets a cell value from an OLAP cube. You cannot write back values with ROC. RWC is the writable version of ROC.

Refer also to CELLGET. CELLGET is similar to ROC but dynamic, and provides greater flexibility in designing reports. If you use the Edit OLAP Formula wizard, a CELLGET formula is created if you click OK in the wizard, without selecting any options.

Syntax

=ROC("data_connection","cube","slice_element {,"slice_element}")

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.

Example

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

Note: To enable writeback in a cell values formula, change ROC to RWC or select Allow writeback of values in the Edit OLAP Formula dialog.

Multiselect

ROC supports multiselect. You can replace any of the elements in a ROC formula with references to valid multiselect XML (MLS-XML). The references can be to cells or to variables which contain MLS-XML.

Example

In this example, an element from the PRODUCT dimension is replaced by a reference to a report variable which contains MLS-XML.

=ROC("BestPractices OLAP","ANALYSIS","[CHANNEL].[All Channels]","[MEASURE].[Gross Margin]",
"[POS].[All Pos]",ReportVariables.rv_multi.Text,"[Period].[All Years]","[REGION].[All Regions]",
"[VALTYPE].[Variance]")