View or update base measures

Pentaho Business Analytics

Version

10.1.x

Audience

anonymous

Part Number

MK-95PDIA004-17

These instructions are for both measures and calculated measures created in PDI and published in Analyzer. Be aware that there are some slight differences in the Properties dialog box based on whether you have selected a measure or a calculated measure.

In the Available fields list on the left, click the name of the measure you want to view or edit, and then click the Down Arrow to the right of the measure name.
A shortcut menu appears.
Click Properties.
The Properties dialog box for that measure displays.
Note: Note that if you are assigned the Manage Data Sources operation permission, you can edit several of these fields. Otherwise, these fields are read-only.

You can view and/or edit the following fields.

Field	Description
Display Name	The name of the measure as it displays in the model.
Aggregation	The aggregation type is how the measure combines the data. Use the drop-down list to select an aggregation type from a system-defined list. Options include: SUM AVERAGE COUNT COUNT_DISTINCT MINIMUM MAXIMUM Note that COUNT and COUNT-DISTINCT are only applicable for non-numeric fields. This field only displays for measures, not for calculated measures.
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 select the Text icon next to the field to enter a custom format. See Format Field Options for more information on selecting the appropriate format for your report.
Description	The description of the measure, if any. This field is always read-only.
Type	The type of field, such as measure. This field is always read-only.
MDX	The formula for the measure as an MDX statement. This field is always read-only.

When finished editing, click OK to save and apply your changes, or Cancel to close the dialog box without saving your changes to the measure.