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.

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