Dimension Object (ADO MD)

Represents one of the dimensions of a multidimensional cube, containing one or more hierarchies of members.

Remarks

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 Hierarchy objects that make up the Dimension with the Hierarchies collection.

  • Use the standard ADO Properties collection to obtain additional information about the Dimension object.

The Properties collection contains provider-supplied properties. The following table lists properties that might be available. 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.
CubeName The name of the cube.
DefaultHierarchy The unique name of the default hierarchy.
Description A meaningful description of the cube.
DimensionCaption A label or caption associated with the dimension.
DimensionCardinality The number of members in the dimension.
DimensionGUID The GUID of the dimension.
DimensionName The name of the dimension.
DimensionOrdinal The ordinal number of the dimension among the group of dimensions that form the cube.
DimensionType The dimension type.
DimensionUniqueName The unambiguous name of the dimension.
SchemaName The name of the schema to which this cube belongs.

This section contains the following topic.

See Also

CubeDef Example (VBScript)
CubeDef Object (ADO MD)
Dimensions Collection (ADO MD)
Hierarchies Collection (ADO MD)
Properties Collection (ADO)