Hierarchy Object (ADO MD)

Represents one way in which the members of a dimension can be aggregated or "rolled up." A dimension can be aggregated along one or more hierarchies.

Remarks

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

  • Identify the Hierarchy with the Name and UniqueName properties.

  • Return a meaningful string that describes the Hierarchy with the Description property.

  • Return the Level objects that make up the Hierarchy with the Levels collection.

  • Use the standard ADO Properties collection to obtain additional information about the Hierarchy 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
AllMember The member at the highest level of rollup in the hierarchy.
CatalogName The name of the catalog to which this cube belongs.
CubeName The name of the cube.
DefaultMember The unique name of the default member for this hierarchy.
Description A meaningful description of the hierarchy.
DimensionType The type of dimension to which this hierarchy belongs.
DimensionUniqueName The unambiguous name of the dimension.
HierarchyCaption A label or caption associated with the hierarchy.
HierarchyCardinality The number of members in the hierarchy.
HierarchyGUID The GUID of the hierarchy.
HierarchyName The name of the hierarchy.
HierarchyUniqueName The unambiguous name of the hierarchy.
SchemaName The name of the schema to which this cube belongs.

This section contains the following topic.

See Also

CubeDef Example (VBScript)
Dimension Object (ADO MD)
Hierarchies Collection (ADO MD)
Levels Collection (ADO MD)
Properties Collection (ADO)