Working with Member Formulas

You can define or edit member formulas directly in the Edit Member Properties grid, in the formula bar, or in the Member Formula dialog where you can validate 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.

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

To define or edit member formulas in the Simplified dimension editor:

  1. View Edit Member Properties.
  2. In the Default Formula column of the grid, select the member for which you want to define or edit a formula. Define or edit the formula for the member using one of the following options:

    • Click within the formula bar above the dimension editor grid, and then enter or edit the formula.

    • Click Member Formula icon (Member Formula) next to the formula bar, and then enter or edit the formula.

    Note:

    • Double-clicking the formula cell used to display a multi-line popup with OK or Cancel. We've removed the popup, and instead it's a direct edit within the formula cell.

    • The formula bar displays when a formula cell is highlighted, and is hidden when you navigate away from the formula cell.

    • We recommend you edit formulas using the formula bar or using the script editor that opens when you click Member Formula icon (Member Formula).

    Tip:

    • If you don't see the Default Formula column, you'll need to add it to the grid. Click Select Columns icon to open the Select Columns dialog, expand Member Formula, select Default Formula, and then click OK. After selecting it, the Default Formula column will be included in the grid for all subsequent sessions.

    • To include member names in formulas, keep the focus on the formula cell in the grid. Press Ctrl while clicking the member name you want to include in the formula. The member name will display in the formula bar.

  3. Optional: To check the validity of a member formula, click Member Formula icon (Member Formula) next to the formula bar, and then click Validate.
  4. Click Save.