Export (0) Print
Expand All

MDSCHEMA_DIMENSIONS Rowset

Describes the shared and private dimensions within a database.

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.

NoteNote
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.

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.

Community Additions

ADD
Show:
© 2014 Microsoft