Working with Member Formulas
You can define or edit member formulas directly in the Simplified dimension editor 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:
- View Edit Member Properties. See Accessing the Simplified Dimension Editor.
- 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 the cell once more in the dimension editor grid to enter or edit the formula.
-
Click within the formula bar above the dimension editor grid, and then enter or edit the formula.
-
Click
next to the formula bar, and then enter or edit the formula.
-
If you don't see the Default Formula column, you'll need to add it to the grid. Click
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.
- Optional: To check the validity of a member formula, click
next to the formula bar, and then click Validate.
- Click Save.
-