Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

MDSCHEMA_MEASUREGROUP_DIMENSIONS 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).

Enumerates the dimensions of measure groups.

The MDSCHEMA_MEASUREGROUP_DIMENSIONS 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.

MEASUREGROUP_CARDINALITY

DBTYPE_WSTR

The number of instances a measure in the measure group can have for a single dimension member. Possible values include:

  • ONE

  • MANY

DIMENSION_UNIQUE_NAME

DBTYPE_WSTR

The unique name for the dimension.

DIMENSION_CARDINALITY

DBTYPE_WSTR

The number of instances a dimension member can have for a single instance of a measure group measure.

Possible values include:

  • ONE

  • MANY

DIMENSION_IS_VISIBLE

DBTYPE_BOOL

A Boolean that indicates whether hieararchies in the dimension are visible.

Returns TRUE if one or more hierarchies in the dimension is visible; otherwise, FALSE.

DIMENSION_IS_FACT_DIMENSION

DBTYPE_BOOL

A Boolean that indicates whether the dimension is a fact dimension.

Returns TRUE if the dimension is a fact dimension; otherwise, FALSE.

DIMENSION_PATH

DBTYPE_HCHAPTER

A list of dimensions for the reference dimension.

DIMENSION_GRANULARITY

DBTYPE_WSTR

The unique name of the granularity hierarchy.

The rowset supports sorting on CATALOG_NAME, SCHEMA_NAME, CUBE_NAME, MEASUREGROUP_NAME, DIMENSION_UNIQUE_NAME.

The MDSCHEMA_MEASUREGROUP_DIMENSIONS 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.

MEASUREGROUP_NAME

DBTYPE_WSTR

Optional.

DIMENSION_UNIQUE_NAME

DBTYPE_WSTR

Optional.

DIMENSION_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.

Community Additions

ADD
Show:
© 2015 Microsoft