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. |
