DIMENSIONS Schema Rowset

Standard Mapping

The DIMENSIONS schema rowset returns metadata about the dimensions that are available on each cube that can be accessed by the provider. Each row in the DIMENSIONS schema rowset corresponds to a dimension that is available on a particular cube.
The following table describes the columns that are available in the DIMENSIONS schema rowset.
Standard Mapping
Column Name
Type Indicator
Mapped Value
Restrictions Supported?
CATALOG_NAME
DBTYPE_WSTR
Name of the catalog that contains this dimension.
Yes
SCHEMA_NAME
DBTYPE_WSTR
Name of the schema that contains this dimension.
Yes
CUBE_NAME
DBTYPE_WSTR
Name of the cube that contains this dimension.
Yes
DIMENSION_NAME
DBTYPE_WSTR
Name of this dimension.
Yes
DIMENSION_UNIQUE_NAME
DBTYPE_WSTR
Unique name of this dimension.
Yes
DIMENSION_GUID
DBTYPE_GUID
GUID of this dimension.
No
DIMENSION_CAPTION
DBTYPE_WSTR
Caption of this dimension. Same as DIMENSION_NAME if no caption exists for this dimension.
No
DIMENSION_ORDINAL
DBTYPE_UI4
Ordinal number of this dimension. This ordinal is relative only to the other dimensions in the same cube.
No
DIMENSION_TYPE
DBTYPE_I2
Type of this dimension. There are four types
  • MD_DIMTYPE_TIME, which is a time dimension.
  • MD_DIMTYPE_MEASURE, which is a measures dimension.
  • MD_DIMTYPE_OTHER, which is neither a time nor a measures dimension.
  • MD_DIMTYPE_UNKNOWN, which is an unknown type.
No
DIMENSION_CARDINALITY
DBTYPE_UI4
Number of members contained by this dimension.
No
DEFAULT_HIERARCHY
DBTYPE_WSTR
Default hierarchy of this dimension.
No
DESCRIPTION
DBTYPE_WSTR
Description of this dimension.
No
Note: For more information about restrictions, see How to Restrict the Rows That Are Returned.
Copyright © SAS Institute Inc. All rights reserved.