Working with Member Formulas

Define member formulas to perform custom calculations on dimension members, enabling precise data modeling.

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.

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

To define member formulas:

  1. Click the Navigator icon Navigator icon.
  2. Under Create and Manage, click Dimensions.
  3. Select the dimension for whose member to add or change a formula.
  4. Select the member and click Edit.
  5. Select the Member Formula tab.
  6. Select options for the following fields:

    • Cube

      Note:

      A formula entered for the default cube is applied to all cubes unless it is overridden by a different formula entered for a specific cube.

      To move the formula from the default cube to a specific cube, you can use Smart View. Find the formula and cut it from the default cube and paste it into a specific cube, for example, Consol.

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

    • Solve Order—For Extended Dimensionality applications, solve order determines the order in which formulas are evaluated. To set this property, you use the Application Configuration page. See Applying SolveOrder for Metadata in Administering Financial Consolidation and Close .

  7. In the text box, define formulas for the member.
  8. Optional: To check the validity of the member formula, click Verify Syntax.
  9. Click Save.

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