Hierarchy object (ADO MD)

Applies to: Access 2013, Office 2013

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.