TechNet
Export (0) Print
Expand All

MDSCHEMA_MEASUREGROUPS Rowset

 

Applies To: SQL Server 2016 Preview

Describes the measure groups within a database.

The MDSCHEMA_MEASUREGROUPS rowset contains the following columns.

Column nameType indicatorLengthDescription
CATALOG_NAMEDBTYPE_WSTRThe name of the catalog to which this measure group belongs. NULL if the provider does not support catalogs.
SCHEMA_NAMEDBTYPE_WSTRNot supported.
CUBE_NAMEDBTYPE_WSTRThe name of the cube to which this measure group belongs.
MEASUREGROUP_NAMEDBTYPE_WSTRThe name of the measure group.
DESCRIPTIONDBTYPE_WSTRA human-readable description of the member.
IS_WRITE_ENABLEDDBTYPE_BOOLA Boolean that indicates whether the measure group is write-enabled.

Returns true if the measure group is write enabled.
MEASUREGROUP_CAPTIONDBTYPE_WSTRThe 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.

Column nameType indicatorRestriction State
CATALOG_NAMEDBTYPE_WSTROptional.
SCHEMA_NAMEDBTYPE_WSTROptional.
CUBE_NAMEDBTYPE_WSTROptional.
MEASUREGROUP_NAMEDBTYPE_WSTROptional.

OLE DB for OLAP Schema Rowsets

Community Additions

ADD
Show:
© 2016 Microsoft