This topic has not yet been rated - Rate this topic

MDSCHEMA_MEASUREGROUPS Rowset

SQL Server 2005

Describes the measure groups within a database.

The MDSCHEMA_MEASUREGROUPS rowset contains the following columns.

Column name	Type indicator	Description
CATALOG_NAME	DBTYPE_WSTR	The name of the catalog to which this measure group belongs. NULL if the provider does not support catalogs.
SCHEMA_NAME	DBTYPE_WSTR	Not supported.
CUBE_NAME	DBTYPE_WSTR	The name of the cube to which this measure group belongs.
MEASUREGROUP_NAME	DBTYPE_WSTR	The name of the measure group.
DESCRIPTION	DBTYPE_WSTR	A human-readable description of the member.
IS_WRITE_ENABLED	DBTYPE_BOOL	A Boolean that indicates whether the measure group is write-enabled. Returns true if the measure group is write enabled.
MEASUREGROUP_CAPTION	DBTYPE_WSTR	The display caption for the measure group.

This schema rowset is not sorted.

The MDSCHEMA_MEASUREGROUPS rowset can be restricted on the columns in the following table.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions