Member formulas support Essbase native formulas and formula expressions that are evaluated and expanded into Essbase code blocks when the database is refreshed. In these expressions, you can address Smart Lists by name, which are replaced with their numerical values in calculations.
You can include predefined formula expressions in member formulas, and test them after you deploy an application using the Validate button in the Memo Editor. You can also load them using Oracle Hyperion Application Link or Shared Services.
You can update the dimension outline without updating all the business rules and calc scripts that depend on the outline. Calculations become more independent of specifics in the outline. Performance is not decreased when you use formula expressions because they are run only when you refresh the database.
To use a formula expression in a member formula:
-
In the Memo Editor dialog box, define formulas for the member.
You can include formula expressions and Essbase native formulas in the member formula. See the Oracle Essbase Database Administrator’s Guide for syntax, rules, and usage on Essbase native formulas.
Planning provides predefined formula expressions that you can use in member formulas. You cannot edit or create your own formula expressions. See Formula Expressions.
.