Creating and editing ROC and RWC formulas

You can create ROC and RWC and formulas in the Edit OLAP Formula wizard, or in the Insert Function dialog.

See these topics:

We recommend that you use the Edit OLAP Formula wizard to create and edit these formulas.

ROC and RWC are cell values formulas. The Wizard for cell values formulas has two columns: Dimensions and Elements. The Dimensions column displays the dimensions of the selected cube. For each dimension, the Elements column displays either:

  • The element to be used in the formula, or
  • A reference to a list object, cell or variable which contains the element to be used

Referencing list objects, cells or variables enables you to create dynamic reports. For example, instead of specifying a single year in a formula, you could insert a list of years in a combo box. If the formula references the combo box, users can select the year on which to report.

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

  1. In Design Mode, click the cell in which to create the formula and then click Edit OLAP Formula on the Objects tool bar.
  2. Select the database alias to use.
    If you are creating the formula in a Value cell of a hyperblock, the appropriate database alias is automatically selected.
  3. Select the Cube to use.
    The Dimensions list is populated with the dimensions and elements of the selected cube.

    If the report already contains list objects that are linked to lists, the Elements column contains references to those list objects. And, if the formula is inserted in a Value cell of a hyperblock, or overlapping hyperblocks, the Elements column contains the cell references of those hyperblocks. Otherwise, the Elements column contains the default element of each dimension.

  4. Optionally, clear the Display caption check box to display the unique names of the elements.
  5. Specify the elements, or references to elements, to use in the formula.

    To change the element to use in the formula, click the browse button between the Dimension and Element columns.

    To reference a list object, cell, or variable, double-click the element and select the reference from the drop-down list.

  6. To create and ROA formula, select Allow writeback of values.
  7. Click OK.
Parent topic: Specifying formulas