MEASURES Rowset

The MEASURES rowset contains information about the available measures. It has the following structure:

Column name Type indicator Description
CATALOG_NAME DBTYPE_WSTR The name of the catalog to which this measure belongs. NULL if the provider does not support catalogs.
SCHEMA_NAME DBTYPE_WSTR The name of the schema to which this measure belongs. NULL if the provider does not support schemas.
CUBE_NAME DBTYPE_WSTR Name of the cube to which this measure belongs.
MEASURE_NAME DBTYPE_WSTR Name of the measure.
MEASURE_
UNIQUE_NAME
DBTYPE_WSTR Unique name of the measure. For providers that generate unique names by qualification, each component of this name is delimited.
MEASURE_CAPTION DBTYPE_WSTR A label or a caption associated with the measure. Used primarily for display purposes. If a caption does not exist, MEASURE_NAME is returned.
MEASURE_GUID DBTYPE_GUID Measure GUID. NULL if the measure does not have a GUID.
MEASURE_
AGGREGATOR
DBTYPE_I4 How a measure was derived. Can be one of the following values:
  • MDMEASURE_AGGR_SUM

  • MDMEASURE_AGGR_COUNT

  • MDMEASURE_AGGR_MIN

  • MDMEASURE_AGGR_MAX

  • MDMEASURE_AGGR_AVG

  • MDMEASURE_AGGR_VAR

  • MDMEASURE_AGGR_STD

    The aggregation function was SUM, COUNT, MIN, MAX, AVG, VAR, or STDEV, respectively.

  • MDMEASURE_AGGR_CALCULATED

    The measure was derived from a formula that was not any single function above.

  • MDMEASURE_AGGR_UNKNOWN

    The aggregation function or formula used to derive this measure was unknown.

DATA_TYPE DBTYPE_UI2 Data type of the measure. Can be any of the types listed in Appendix A of the OLE DB Programmer's Reference.
NUMERIC_PRECISION DBTYPE_UI2 If the measure object’s data type is exact numeric, this is the maximum precision of the property. NULL for all other property types.
NUMERIC_SCALE DBTYPE_I2 If the measure object’s type indicator is DBTYPE_NUMERIC or DBTYPE_DECIMAL, this is the number of digits to the right of the decimal point. Otherwise, this is NULL.
MEASURE_UNITS DBTYPE_WSTR The unit of measurement. Some examples are “dollars,” “boxes sold,” “tons shipped,” “pounds,” and “millions.” Typically, a consumer appends this to the display caption of the measure. If a unit is not available, the provider returns an empty string.
DESCRIPTION DBTYPE_WSTR A human-readable description of the measure. NULL if no description exists.

The default sort order is: CATALOG_NAME, SCHEMA_NAME, CUBE_NAME, and MEASURE_NAME.