MDSCHEMA_MEASUREGROUP_DIMENSIONS Rowset

Enumerates the dimensions of measure groups.

Rowset Columns

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.

Restriction Columns

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.

See Also

OLE DB for OLAP Schema Rowsets