Skip to main content
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". ("distinct count" 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}.
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.