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.