Creating calculation dimensions with N calculations using dimension functions

An 'N' calculation using a dimension function is a calculation performed at the dimension level between an input value of a member of that dimension and the function selected.

The expression editor has built-in functions that use member values as input for calculations. A function expression is derived from the dimension function and an input value and in some instances also a pad value. The expression editor helps in the selection of the dimension functions.

Procedure

  1. In the Model Design pane, right-click the Dimensions folder and click the New icon New icon.
  2. Click the Dimension icon Dimension icon.
  3. Type the name of the new dimension and select Calculation from the Dimension type list.
  4. Add the members of the dimension to the Name attribute either by typing the list or doing a copy/paste action.
    For example: Quantity, Price, Revenue,
    Cost of Sales,
    Net Sales.
  5. Save the dimension.
  6. Open the calculation dimension to edit.
  7. To add a function with the expression editor, click the cell where you want to add the function.
  8. Click the More button in that cell.
    The expression editor opens.
  9. Click the Functions tab and expand the Dimension Functions tree.
  10. Select the function type and drag the function to the expression editor.
    If you click the Tips tab, the power editing support opens that gives a detailed explanation of the function selected.
  11. In the Expression field, drag and drop the member into the expression editor over the <Input> field.
    You can also type the name of the member for the field. The name of the member must be identical to the member name in the name attribute. If the name has two words, the name shows in single quote marks.
  12. Save the dimension.