MDSCHEMA_MEASURES Rowset
Describes each measure within a cube.
The MDSCHEMA_MEASURES rowset contains the following columns.
Column name |
Type indicator |
Length |
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 |
|
The name of the cube to which this measure belongs. |
MEASURE_NAME |
DBTYPE_WSTR |
|
The name of the measure. |
MEASURE_UNIQUE_NAME |
DBTYPE_WSTR |
|
The 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 caption associated with the measure. Used primarily for display purposes. If a caption does not exist, MEASURE_NAME is returned. |
MEASURE_GUID |
DBTYPE_GUID |
|
Not supported. |
MEASURE_AGGREGATOR |
DBTYPE_I4 |
|
An enumeration that identifies how a measure was derived. Can be one of the following values:
|
DATA_TYPE |
DBTYPE_UI2 |
|
The data type of the measure. |
NUMERIC_PRECISION |
DBTYPE_UI2 |
|
The maximum precision of the property if the measure object's data type is exact numeric. NULL for all other property types. |
NUMERIC_SCALE |
DBTYPE_I2 |
|
The number of digits to the right of the decimal point if the measure object's type indicator is DBTYPE_NUMERIC or DBTYPE_DECIMAL. Otherwise, this value is NULL. |
MEASURE_UNITS |
DBTYPE_WSTR |
|
Not supported |
DESCRIPTION |
DBTYPE_WSTR |
|
A human-readable description of the measure. NULL if no description exists. |
EXPRESSION |
DBTYPE_WSTR |
|
An expression for the member. |
MEASURE_IS_VISIBLE |
DBTYPE_BOOL |
|
A Boolean that always returns True. If the measure is not visible, it will not be included in the schema rowset. |
LEVELS_LIST |
DBTYPE_WSTR |
|
A string that always returns NULL. |
MEASURE_NAME_SQL_COLUMN_NAME |
DBTYPE_WSTR |
|
The name of the column in the SQL query that corresponds to the measure's name. |
MEASURE_UNQUALIFIED_CAPTION |
DBTYPE_WSTR |
The name of the measure, not qualified with the measure group name. |
|
MEASUREGROUP_NAME |
DBTYPE_WSTR |
|
The name of the measure group to which the measure belongs. |
MEASURE_DISPLAY_FOLDER |
DBTYPE_WSTR |
|
The path to be used when displaying the measure in the user interface. Folder names will be separated by a semicolon. Nested folders are indicated by a backslash (\). |
DEFAULT_FORMAT_STRING |
DBTYPE_WSTR |
The default format string for the measure. |
The rowset is sorted on CATALOG_NAME, SCHEMA_NAME, CUBE_NAME, MEASURE_NAME.
The MDSCHEMA_MEASURES rowset can be restricted on the columns listed in the following table.
Column name |
Type indicator |
Restriction State |
---|---|---|
CATALOG_NAME |
DBTYPE_WSTR |
Optional. |
SCHEMA_NAME |
DBTYPE_WSTR |
Optional. |
CUBE_NAME |
DBTYPE_WSTR |
Optional. |
MEASURE_NAME |
DBTYPE_WSTR |
Optional. |
MEASURE_UNIQUE_NAME |
DBTYPE_WSTR |
Optional. |
MEASUREGROUP_NAME |
DBTYPE_WSTR |
Optional. |
CUBE_SOURCE |
DBTYPE_UI2 |
(Optional) A bitmap with one of the following valid values:
Default restriction is a value of 1. |
MEASURE_VISIBILITY |
DBTYPE_UI2 |
(Optional) A bitmap with one of the following valid values:
Default restriction is a value of 1. |