MDSCHEMA_DIMENSIONS Rowset

Describes the shared and private dimensions within a database.

Rowset Columns

The MDSCHEMA_DIMENSIONS rowset contains the following columns:

Column name

Type indicator

Length

Description

CATALOG_NAME

DBTYPE_WSTR

The name of the database.

SCHEMA_NAME

DBTYPE_WSTR

Not supported.

CUBE_NAME

DBTYPE_WSTR

The name of the cube.

DIMENSION_NAME

DBTYPE_WSTR

The name of the dimension. If a dimension is part of more than one cube or measure group, then there is one row for each unique combination of dimension, measure group, and cube.

DIMENSION_UNIQUE_NAME

DBTYPE_WSTR

The unique name of the dimension.

DIMENSION_GUID

DBTYPE_GUID

Not supported.

DIMENSION_CAPTION

DBTYPE_WSTR

The caption of the dimension. This should be used when displaying the name of the dimension to the user, such as in the user interface or reports.

DIMENSION_ORDINAL

DBTYPE_UI4

The position of the dimension within the cube.

DIMENSION_TYPE

DBTYPE_I2

The type of the dimension. Valid values include:

• MD_DIMTYPE_UNKNOWN (0)
• MD_DIMTYPE_TIME (1)
• MD_DIMTYPE_MEASURE (2)
• MD_DIMTYPE_OTHER (3)
• MD_DIMTYPE_QUANTITATIVE (5)
• MD_DIMTYPE_ACCOUNTS (6)
• MD_DIMTYPE_CUSTOMERS (7)
• MD_DIMTYPE_PRODUCTS (8)
• MD_DIMTYPE_SCENARIO (9)
• MD_DIMTYPE_UTILIY (10)
• MD_DIMTYPE_CURRENCY (11)
• MD_DIMTYPE_RATES (12)
• MD_DIMTYPE_CHANNEL (13)
• MD_DIMTYPE_PROMOTION (14)
• MD_DIMTYPE_ORGANIZATION (15)
• MD_DIMTYPE_BILL_OF_MATERIALS (16)
• MD_DIMTYPE_GEOGRAPHY (17)

DIMENSION_CARDINALITY

DBTYPE_UI4

The number of members in the key attribute.

DEFAULT_HIERARCHY

DBTYPE_WSTR

A hierarchy from the dimension. Preserved for backwards compatibility.

DESCRIPTION

DBTYPE_WSTR

A user-friendly description of the dimension.

IS_VIRTUAL

DBTYPE_BOOL

Always FALSE.

IS_READWRITE

DBTYPE_BOOL

A Boolean that indicates whether the dimension is write-enabled.

TRUE if the dimension is write-enabled.

DIMENSION_UNIQUE_SETTINGS

DBTYPE_I4

A bitmap that specifies which columns contain unique values if the dimension contains only members with unique names. The following bit value constants are defined in Msmd.h for this bitmap:

• MDDIMENSIONS_MEMBER_KEY_UNIQUE

DIMENSION_MASTER_UNIQUE_NAME

DBTYPE_WSTR

Always NULL.

DIMENSION_IS_VISIBLE

DBTYPE_BOOL

Always TRUE.

Note:

A dimension is not visible unless one or more hierarchies in the dimension are visible.

The rowset is sorted on CATALOG_NAME, SCHEMA_NAME, CUBE_NAME, DIMENSION_NAME.

Restriction Columns

The MDSCHEMA_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.
DIMENSION_NAME	DBTYPE_WSTR	Optional.
DIMENSION_UNIQUE_NAME	DBTYPE_WSTR	Optional.
CUBE_SOURCE	DBTYPE_UI2	(Optional) A bitmap with one of the following valid values: 1 CUBE 2 DIMENSION Default restriction is a value of 1.
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

Reference

OLE DB for OLAP Schema Rowsets

Help and Information

Getting SQL Server 2005 Assistance