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