Editing formulas in the Edit OLAP Formula wizard

You can edit all formulas manually in a report in Design mode. But these formulas can also be edited in the Edit OLAP Formula wizard:

  • CELLGET: Cell values formula
  • ROC: Cell values formula
  • RWC: Cell values formula
  • NOTEGET: Cell notes formula (cell comments)
  • RON: Cell notes formula
  • RWN: Cell notes formula
  • CELLPROPERTYGET: Cell properties formula
  • SLICEGET: Slice values formula
  • ROA: Attributes formula
  • RWA: Attributes formula
  • ROK: KPI formula

To edit a formula in the Edit OLAP Formula wizard:

  1. Click the cell that contains the formula.
  2. Click Edit OLAP Formula in the Objects tool bar.