Working with Member Formulas

You can define member formulas to 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 allowed in formulas.

  See the Oracle Essbase Database Administrator's Guide.

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

To define member formulas:

1. Select Administration, then Manage, then Dimensions.
2. Select the dimension for whose member to add or change a formula.
3. Select the member and click Edit.
4. Select the Member Formula tab.
5. Select options for the following fields:

   • Plan Type

     Note:

     A formula entered for the default plan type will be applied to all plan types unless it is overridden by a different formula entered for a specific plan type.

   • Data Storage—Select a data storage option. The default is Store.

     Note:

     The plan type specific data storage field will not display the Shared or Label Only options. This is because a member cannot be set to Shared or Label Only in one plan type and not another.

   • Solve Order—For aggregate storage plan types only, solve order specifies the order in which formulas are evaluated. Enter a whole number between 0 and 100000 (or use arrows to increase or decrease the number). The formulas for members that have a specified solve order are calculated in order from the lowest solve order to the highest. The default is 0.

6. In the text box, define formulas for the member.

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

7. Optional: To check the validity of the member formula, click Validate.
8. Click Save.

   Before you click Save, clicking Reset restores the previous member formula information.