MDSCHEMA_MEASURES Rowset

Describes each measure within a cube.

Rowset Columns

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: MDMEASURE_AGGR_SUM (1) MDMEASURE_AGGR_COUNT (2) MDMEASURE_AGGR_MIN (3) MDMEASURE_AGGR_MAX (4) MDMEASURE_AGGR_AVG (5) MDMEASURE_AGGR_VAR (6) MDMEASURE_AGGR_STD (7) identifies that the measure was derived from an aggregation function that was SUM, COUNT, MIN, MAX, AVG, VAR, or STDEV, respectively. MDMEASURE_AGGR_CALCULATED (127) identifies that the measure was derived from a formula that was not any single function above. MDMEASURE_AGGR_UNKNOWN (0) identifies that the measure was derived from an unknown aggregation function or formula.
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.

Restriction Columns

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: 1 CUBE 2 DIMENSION Default restriction is a value of 1.
MEASURE_VISIBILITY	DBTYPE_UI2	(Optional) A bitmap with one of the following valid values: 1 Visible 2 Not Visible Default restriction is a value of 1.

See Also

Reference

OLE DB for OLAP Schema Rowsets

Help and Information

Getting SQL Server 2005 Assistance