Working with Member Formulas

Subtopics

You can define member formulas in the Property Grid for Planning, Profitability, Essbase (ASO), and Essbase (BSO) categories. Member formulas can combine operators, calculation functions, dimension and member names, and numeric constants to perform calculations on members. Member formulas can also include:

  • Operator type, function, value, member name, UDA, and so on that are allowed in Essbase formulas (see the Oracle Essbase Database Administrator’s Guide and Online Help)

  • Predefined formula expressions—including Smart List values—that expand into a formula or value upon database refresh

  To define member formulas:

  1. Select the dimension member to add or change a formula.

    Note:

    The Member Formula property displays in the following categories: Planning, Essbase (ASO), and Essbase (BSO).

  2. In the Property Grid, double-click Member Formula.

  3. Click Ellipsis Button.

    The Memo Editor dialog box is displayed.

    See the Oracle Essbase Database Administrator’s Guide for syntax, rules, and usage on Essbase formulas.

  4. To wrap the formula text, click Word Wrap.

  5. Click OK.