Export (0) Print
Expand All

MDSCHEMA_DIMENSIONS Rowset

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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.

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

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:
© 2015 Microsoft