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:
|
|
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.
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.
|
Reference
OLE DB for OLAP Schema Rowsets
Help and Information
Getting SQL Server 2008 Assistance