Dimension Object (ADO MD)

A Dimension object represents a dimension of a cube, and contains one or more Hierarchies of Members.

Remarks

A Dimension object can be contained by a Dimensions collection.

With the collections and properties of a Dimension object, you can do the following:

Identify the Dimension with the Name and UniqueName properties.
Return a meaningful string that describes the Dimension with the Description property.
Return the Hierarchies that make up the Dimension with the Hierarchies collection.
Use the Properties collection to obtain additional information about the Dimension object.

The Properties collection contains provider-supplied properties. The following properties should be available, but the actual property list may differ depending upon the implementation of the provider. See the documentation for your provider for a more complete list of available properties.

Name	Description
CatalogName	The name of the catalog to which this cube belongs.
SchemaName	The name of the schema to which this cube belongs.
CubeName	The name of the cube.
DimensionName	The name of the dimension.
DimensionUniqueName	The unique name of the dimension.
DimensionGUID	The GUID of the dimension.
DimensionCaption	A label or caption associated with the dimension.
DimensionOrdinal	The ordinal number of the dimension among the group of dimensions that form the cube.
DimensionType	The dimension type.
DimensionCardinality	The number of members in the dimension.
DefaultHierarchy	The unique name of the default hierarchy.
Description	A meaningful description of the cube.