ROC

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

See RWC.

Refer also to Cellget. Cellget is similar to ROC but dynamic, and provides greater flexibility in designing reports.

If you use the Formula Wizard, ROC is the default formula. That is if you click OK in the Wizard, without making any changes, an ROC formula is created.

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 ROC formulas cease to work.

SeeInfor CPM Relational Provider.

The ROC syntax:

=ROC("Database Alias", "Cube", "Slice element dimension 1 ",..."slice element dimension N")

Example

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

Note: To enable write back 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("Best Practices OLAP","ANALYSIS","[CHANNEL].[All Channels]","[MEASURE].[Gross Margin]",
"[POS].[All Pos]",ReportVariables.rv_multi.Text,"[Period].[All Years]","[REGION].[All Regions]",
"[VALTYPE].[Variance]")

These are other formulas that support multiselect: