Jaa


MDSCHEMA_MEASUREGROUPS Rowset

Describes the measure groups within a database.

Rowset Columns

The MDSCHEMA_MEASUREGROUPS rowset contains the following columns.

Column name Type indicator Length 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.

Restriction Columns

The MDSCHEMA_MEASUREGROUPS rowset can be restricted on the columns 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.

MEASUREGROUP_NAME

DBTYPE_WSTR

Optional.

See Also

Reference

OLE DB for OLAP Schema Rowsets

Help and Information

Getting SQL Server 2005 Assistance