Resources

• Products & Solutions
• System Requirements
• Samples
• Install Center
• Third-Party Software Reference
• Documentation
  • What's New in SAS
  • Product Index A-Z
  • SAS Viya
  • SAS 9.4
  • SAS 9.3 and Earlier
• Papers
• Focus Areas

DIMENSIONS Schema Rowset

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.

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, either: 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 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

Restricting Returned Rows

Restrictions enable an OLE DB consumer to restrict the rows that are returned in a schema rowset by IDBSchemaRowset::GetRowset. A restriction is a value for a specific column. When a restriction is passed to IDBSchemaRowset::GetRowset, all rows that are returned in the schema rowset must match the restriction value on the specified column. Restriction values do not support pattern matching or wildcards. For example, the restriction value D_F matches D_F but not DEF.

An OLE DB consumer can programmatically discover the columns on which the providers support restrictions by calling IDBSchemaRowset::GetSchemas.

Note: For definitions of the type indicators, see "Type Indicators" in Microsoft's OLE DB specification documentation.