Edit OLAP Formula wizard

You can create these formulas in the Edit OLAP Formula wizard:

  • ROC: Cell Values formula
  • RWC: Writable Cell Values formula
  • ROA: Attributes formula
  • RWA: Writable Attributes formula
  • ROK: KPI formula

You can also create these formulas manually in the Insert Function dialog.

See Insert Function.

To open the dialog, click Edit OLAP Formula on the Objects tool bar. Or, select Extras > Edit OLAP Formulaon the Standard tool bar.

The layout of the Edit OLAP Formula dialog varies according to whether you select Cell Values, Attributes or KPI as the type of formula.

Note: Where the driver of the database alias is ODBO, the dimensions are ordered alphabetically by unique name in the Edit Formula dialog and in the formula itself. In the database structure, the dimensions are in the same order as in the OLAP Server database.
Related topics