How to: Specify Measures for a Cube
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
-
In the AOT, select the extended data type or the table field to use to define the measure.
-
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.