MDSCHEMA_DIMENSIONS Rowset

MDSCHEMA_DIMENSIONS Rowset

 

Applies To: SQL Server 2016 Preview

Describes the shared and private dimensions within a database.

The MDSCHEMA_DIMENSIONS rowset contains the following columns:

Column nameType indicatorDescription
CATALOG_NAMEDBTYPE_WSTRThe name of the database.
SCHEMA_NAMEDBTYPE_WSTRNot supported.
CUBE_NAMEDBTYPE_WSTRThe name of the cube.
DIMENSION_NAMEDBTYPE_WSTRThe 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_NAMEDBTYPE_WSTRThe unique name of the dimension.
DIMENSION_GUIDDBTYPE_GUIDNot supported.
DIMENSION_CAPTIONDBTYPE_WSTRThe 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_ORDINALDBTYPE_UI4The position of the dimension within the cube.
DIMENSION_TYPEDBTYPE_I2The 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_CARDINALITYDBTYPE_UI4The number of members in the key attribute.
DEFAULT_HIERARCHYDBTYPE_WSTRA hierarchy from the dimension. Preserved for backwards compatibility.
DESCRIPTIONDBTYPE_WSTRA user-friendly description of the dimension.
IS_VIRTUALDBTYPE_BOOLAlways FALSE.
IS_READWRITEDBTYPE_BOOLA Boolean that indicates whether the dimension is write-enabled.

 TRUE if the dimension is write-enabled.
DIMENSION_UNIQUE_SETTINGSDBTYPE_I4A 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_NAMEDBTYPE_WSTRAlways NULL.
DIMENSION_IS_VISIBLEDBTYPE_BOOLAlways 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.

The MDSCHEMA_DIMENSIONS rowset can be restricted on the columns listed in the following table.

Column nameType indicatorRestriction State
CATALOG_NAMEDBTYPE_WSTROptional.
SCHEMA_NAMEDBTYPE_WSTROptional.
CUBE_NAMEDBTYPE_WSTROptional.
DIMENSION_NAMEDBTYPE_WSTROptional.
DIMENSION_UNIQUE_NAMEDBTYPE_WSTROptional.
CUBE_SOURCEDBTYPE_UI2(Optional) Default restriction is a value of 1. A bitmap with one of the following valid values:

1 CUBE

2 DIMENSION
DIMENSION_VISIBILITYDBTYPE_UI2(Optional) Default restriction is a value of 1. A bitmap with one of the following valid values:

1 Visible

2 Not visible

OLE DB for OLAP Schema Rowsets

Community Additions

ADD
Show:
© 2016 Microsoft