Dimension Object
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. |