Skip to main content
Pentaho Documentation

Creating Measures on Stream Fields

A measure is a property that is used to make specific calculations, such as  SUM, AVERAGE, COUNT, COUNT_DISTINCT, MINIMUM, or MAXIMUM. As part of the Annotate Stream and Shared Dimension steps, you can create a measure or series of measures to further refine your data model.

To Create a Measure on a Stream Field

These steps guide you through creating a measure for a field in the stream using the Annotate Stream step.

  1. If you haven't done so already, complete steps 1-7 in Using the Annotate Stream Step.
  2. Select Create Measure from the Actions menu. The Name - Value table auto-populates with a list of annotation properties for the measure.

CreateMeasure2.png

  1. Enter or edit the values for each annotation component.
    Component Description
    Measure Name Enter a name for your annotation.
    Aggregation Type Specify a format string or choose from a list of aggregation types:
    • SUM
    • AVERAGE
    • COUNT
    • COUNT_DISTINCT
    • MINIMUM
    • MAXIMUM
    Note that COUNT and COUNT-DISTINCT are only available for non-numeric fields.
    Format String Choose how this field should be formatted, such as currency, general number, or percentage.
    Description Enter a brief description for the annotation. This description will be available on the BA Server.
    Hidden Set to 'True' to prevent this annotation from displaying as an available measure in Analyzer. When set to 'True', this annotation is included in the model, but it is not visible to users when the model is published and opened in Analyzer.
    Set to 'False' to allow this annotation to display as an available measure in Analyzer. When set to 'False', this annotation is visible to users when the model is published and opened in Analyzer.
    The Hidden property is useful for annotations needed to build a proper data model, but not needed for analytic purposes. For example, if you are in a multi-tenant environment, you may want to hide the 'Tenant ID' annotation while still including it in the data model.
  1. Use the Previous and Next buttons to navigate through the fields. When finished, click OK to save your changes and close the dialog box, or Cancel to close the dialog box without saving your annotations.