MDSCHEMA_MEASUREGROUP_DIMENSIONS Rowset

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 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.
MEASUREGROUP_CARDINALITYDBTYPE_WSTRThe number of instances a measure in the measure group can have for a single dimension member. Possible values include:

 ONE

 MANY
DIMENSION_UNIQUE_NAMEDBTYPE_WSTRThe unique name for the dimension.
DIMENSION_CARDINALITYDBTYPE_WSTRThe number of instances a dimension member can have for a single instance of a measure group measure. Possible values include:

 ONE

 MANY
DIMENSION_IS_VISIBLEDBTYPE_BOOLA 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_DIMENSIONDBTYPE_BOOLA Boolean that indicates whether the dimension is a fact dimension.

Returns TRUE if the dimension is a fact dimension; otherwise, FALSE.
DIMENSION_PATHDBTYPE_HCHAPTERA list of dimensions for the reference dimension.
DIMENSION_GRANULARITYDBTYPE_WSTRThe 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 nameType indicatorRestriction State
CATALOG_NAMEDBTYPE_WSTROptional.
SCHEMA_NAMEDBTYPE_WSTROptional.
CUBE_NAMEDBTYPE_WSTROptional.
MEASUREGROUP_NAMEDBTYPE_WSTROptional.
DIMENSION_UNIQUE_NAMEDBTYPE_WSTROptional.
DIMENSION_VISIBILITYDBTYPE_UI2(Optional) A bitmap with one of the following valid values:

1 Visible

2 Not visible

Default restriction is a value of 1.

OLE DB for OLAP Schema Rowsets

Community Additions

ADD
Show:
© 2016 Microsoft