Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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.
.gif "ms126180.note(en-US,SQL.90).gif")
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:
Default restriction is a value of 1. |
DIMENSION_VISIBILITY |
DBTYPE_UI2 |
(Optional) A bitmap with one of the following valid values:
Default restriction is a value of 1. |
See Also
Reference
OLE DB for OLAP Schema Rowsets