Skip to main content
Hitachi Vantara Lumada and Pentaho Documentation


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.


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