How to: Specify Measures for a Cube

Dynamics AX 2009

Before you specify a measure, you must decide the scope of the measure and where it should be defined. In order to specify a measure on a table field in a perspective, you must have already created the perspective. For more information, see How to: Create a Perspective for a Cube.

The following procedure explains how to specify a measure for a cube.

To specify a measure for a cube

  1. In the AOT, select the extended data type or the table field to use to define the measure.

  2. In the Properties sheet, specify values for the following properties.

    Property

    Value

    AnalysisLabel

    A label for the measure. Only specify a label when the label supplied for the Label property is not appropriate.

    AnalysisUsage

    Measure

    AnalysisDefautTotal

    An aggregate function used to aggregate the measure values.

    If you specify a measure on an extended data type, any table field that references the extended data type and has its AnalysisUsage property set to Auto will be a measure. You can override the settings for the measure on a table field. For example, you may want to change the settings so that the table field is not a measure or specify a different aggregate function for the table field. For a detailed description of the BI properties and their options, see Business Intelligence Properties.

Community Additions

ADD
Show: