MEASURES Schema Rowset

Standard Mapping

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.
Standard Mapping
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. The indicators are as follows:
  • MDMEASURE_AGGR_SUM
  • MDMEASURE_AGGR_COUNT
  • MDMEASURE_AGGR_MIN
  • MDMEASURE_AGGR_MAX
  • MDMEASURE_AGGR_AVG
  • MDMEASURE_AGGR_VAR
  • MDMEASURE_AGGR_STD
  • MDMEASURE_AGGR_CALCULATED
  • MDMEASURE_AGGR_UNKNOWN
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
Note: For more information about restrictions, see How to Restrict the Rows That Are Returned.
Copyright © SAS Institute Inc. All rights reserved.