MDSCHEMA_MEASUREGROUP_DIMENSIONS
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:
|
|
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:
|
|
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:
|