Export (0) Print
Expand All

MDSCHEMA_MEASUREGROUPS Rowset

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

Describes the measure groups within a database.

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.

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2015 Microsoft