View or update inline calculated measures

Pentaho Business Analytics
Version
10.1.x
Audience
anonymous
Part Number
MK-95PDIA004-17
These instructions are for calculated measures created within Analyzer using inline modeling. Note that inline calculated measures display with the function symbol ('fx') in the Available Fields list.
  1. In the Available Fields list on the left, click the name of the calculated measure you want to edit, and then click the down arrow to the right of the measure name.
    A shortcut menu appears.
    Measures shortcut menu
  2. Click Properties.
    The Properties dialog box appears for that calculated measure.
    Editing a calculated measure
  3. You can view and/or edit the following fields.
    Note: Some of the fields only display for users who are assigned the Manage Data Sources permission.
    Field Description
    Name The name of the measure as it displays in the model.
    Format
    Choose how this measure should be formatted, such as currency, general number, or percentage. Use the drop-down arrow to select a format from a system-defined list, or type in the field to enter a custom format.
    Note: The Format field only displays when the value for the field is a number or a date.
    If you do not specify a format, the default value of the first base measure is used as the format. See Format Field Options for more information on selecting the appropriate format for your report.
    Decimal Places (Optional) Specify the number of decimal places for the results.
    Type The type of field, measure, such as calculated measure. This field is always read-only.
    MDX The formula for the measure as an MDX statement. This field is always read-only.
    Formula In the right panel, enter the formula for your calculated measure. You can write the MDX statement, or you can use the list on the left to drag measures into the right panel. You can also use the symbol buttons below to help create your statement, or just use your keyboard to write the expression.
    Create subtotals using measure formula Select this check box to use this calculated measure when adding up subtotals in your report.
  4. When finished editing, click OK to save your changes to the calculated measure to the data source, or Cancel to close the dialog box without saving your changes.