Creating CELLGET formulas in the Edit OLAP Formula wizard

CELLGET is a cell values formula. The Wizard 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 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 CELLGET formula, the name of the object is automatically displayed in the Selection column.

In the Selection column you can select a different report object, or you can open the Edit Formula dialog and specify a formula.

To reference hierarchies that are not linked to report objects, click Select Hierarchy and select from the list. In the Selection column select an element from the hierarchy, or select a variable

To create a CELLGET formula 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 Cell values as the formula type.
  3. Select the data connection to use.
  4. Select the cube to use.
  5. Define the data area by selecting from the Hierarchy and Selection columns.
  6. Click OK.
    The Fixed mode and Allow writeback options enable you to create ROC and RWC formulas.