The MEASURES schema rowset returns metadata about the measures that can be accessed by the provider. Each row in the MEASURES schema rowset corresponds to one measure that is available in the provider.
The following table describes the columns that are available in the MEASURES schema rowset.
| Column Name | Type Indicator | Mapped Value | Restrictions Supported? |
|---|---|---|---|
| CATALOG_NAME | DBTYPE_WSTR | Name of the catalog that contains this measure. | Yes |
| SCHEMA_NAME | DBTYPE_WSTR | Name of the schema that contains this measure. | Yes |
| CUBE_NAME | DBTYPE_WSTR | Name of the cube that contains this measure. | Yes |
| MEASURE_NAME | DBTYPE_WSTR | Name of this measure. | Yes |
| MEASURE_UNIQUE_NAME | DBTYPE_WSTR | Unique name of this measure. | Yes |
| MEASURE_CAPTION | DBTYPE_WSTR | Caption of this measure. Same as MEASURE_NAME if this measure has no caption. | No |
| MEASURE_GUID | DBTYPE_GUID | GUID of this measure. | No |
| MEASURE_AGGREGATOR | DBTYPE_I4 | Indicator of how this measure was derived, either:
|
No |
| DATA_TYPE | DBTYPE_UI2 | Data type of this measure. | No |
| NUMERIC_PRECISION | DBTYPE_UI2 | Maximum numeric precision for numeric measures. NULL for all other measures. | No |
| NUMERIC_SCALE | DBTYPE_I2 | Number of digits to the right of the decimal point for numeric measures. NULL for all other measures. | No |
| MEASURE_UNITS | DBTYPE_WSTR | Unit of this measure. | No |
| DESCRIPTION | DBTYPE_WSTR | Description of this measure. | No |
Restrictions enable an OLE DB consumer to restrict the rows that are returned in a schema rowset by IDBSchemaRowset::GetRowset. A restriction is a value for a specific column. When a restriction is passed to IDBSchemaRowset::GetRowset, all rows that are returned in the schema rowset must match the restriction value on the specified column. Restriction values do not support pattern matching or wildcards. For example, the restriction value D_F matches D_F but not DEF.
An OLE DB consumer can programmatically discover the columns on which the providers support restrictions by calling IDBSchemaRowset::GetSchemas.
Note: For definitions of the type indicators, see "Type Indicators" in Microsoft's OLE DB specification documentation.