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 Essbase formulas (see the Oracle Essbase Database Administrator's Guide).
Predefined Planning formula expressions, including Smart List values, that expand into a formula or value upon database refresh.

To define member formulas:

Select Administration, then Manage, then Dimensions.
Select the dimension for whose member to add or change a formula.
Select the member and click Edit.
Select Member Formula.
In the text box, define formulas for the member.
See the Oracle Essbase Database Administrator's Guide for syntax, rules, and usage on Essbase formulas.
Optional: To check the validity of the member formula, click Validate Member Formula and OK.
Click Save.
Before you click Save, clicking Refresh restores the previous member formula information.