1. Database Administrator's Guide for Oracle Essbase
  2. Dimension and Member Properties
  3. Create Formulas

Create Formulas

You can apply formulas to standard dimensions and members. You cannot set formulas for attribute dimensions and their members. The formula determines how Essbase calculates the outline data.

To learn how to write formulas, refer to Develop Formulas for Block Storage Cubes.

To add formulas to a dimension or member using the Essbase web interface, open the outline for editing, select a member, and edit its properties. Click Formula to add or edit the member formula. For more details, refer to Create Member Formulas.

If you are using an application workbook or Cube Designer to set a formula, update the FORMULA property on the dimension worksheet with the contents of the formula. Refer to Understand Dimension Worksheets.

If you use REST API to edit the outline, you would update the formula property of mbrInfo to add the formula as a string, when performing a member add or update action as documented in the endpoint for Run Batch Outline Edit.