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.

A dimension is not visible unless one or more hierarchies in the dimension are visible.
ms126180.note(en-US,SQL.90).gifNote:

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft