Creating ROC and RWC formulas in the Edit OLAP Formula wizard

ROC and RWC are cell values formulas. The Wizard for cell values formulas has a data area with two columns. The content of the Hierarchy and Selection columns depends on whether hierarchies are linked to report objects.

For each hierarchy that is not linked to a report object, the Hierarchy column displays the hierarchy name. For each hierarchy, the Selection column displays the top level element of the hierarchy. You can select a different element.

For each hierarchy that is linked to a report object, the Hierarchy column displays 'Formula'. The Selection column displays the name of the linked report object. You can select a different report object or, for example, a variable.

If you add a list object to a report after you have created a ROC or RWC formula, you can edit the formula to reference the object. Select the name of the report object in the Selection column. The Hierarchy column displays 'Formula' in place of the hierarchy name.

To break the link between a hierarchy and a report object, click Formula in the Hierarchy column and select an element in the Selection column.

To create ROC and RWC formulas in the Edit OLAP Formula wizard:

In Design mode, click the cell in which to create the formula and then click the Edit OLAP Formula button on the Objects tool bar.
Select Cell values as the formula type.
Select the data connection to use.
Select the cube to use.
To create a ROC formula, select the Fixed mode check box. To create an RWC formula, select Fixed mode and Allow writeback.
The data area is populated with the hierarchies and elements of the selected cube and with references to any report objects that are linked to hierarchies.
Define the data area by selecting from the Hierarchy and Selection columns.
Click OK.