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

 

Applies To: SQL Server 2016 Preview

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