Measure
A measure is an aggregated numeric value. Typically it is a sum of selected numbers in a column, or a count of the number of items in a list.
Attributes
| Attribute | Data Type | Definition |
| name | String | Name of this measure |
| column | String | Column which is source of this measure's values. If not specified, a measure expression must be specified. |
| datatype | String | The datatype of this measure: String, Numeric, Integer, Boolean, Date, Time or Timestamp. The default datatype of a measure is Integer if the measure's aggregator is Count, otherwise it is Numeric. |
| formatString | String | Format string with which to format cells of this measure. For more details, see the mondrian.util.Format class. |
| aggregator | String | Aggregation function. Allowed values are sum, count, min, max, avg, and distinct-count. The distinct count value is allowed for backwards compatibility, but is deprecated because XML enumerated attributes in a DTD cannot legally contain spaces. |
| formatter | String | Name of a formatter class for the appropriate cell being displayed. The class must implement the mondrian.olap.CellFormatter interface. |
| caption | String | A string being displayed instead of the name. Can be localized from Properties file using #{propertyname}. |
| description | String | Description of this measure. Can be localized from Properties file using #{propertyname}. |
| visible | Boolean | Whether this member is visible in the user-interface. Default true. |
Constituent Elements
| Element | Definition |
| MeasureExpression | The SQL expression used to calculate a measure. Must be specified if a source column is not specified. |
| CalculatedMemberProperty | Property of a calculated member |