Hierarchy Object (ADO MD)

A Hierarchy object represents the ways in which the Members of a Dimension can be aggregated or "rolled up." A Dimension can be aggregated along one or more Hierarchy.

Remarks

A Hierarchy object can be contained by a Hierarchies collection.

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 Levels that make up the Hierarchy with the Levels collection.
Use the Properties collection to obtain additional information about the Hierarchy object.

The Properties collection contains provider-supplied properties. The following properties should be available, but 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.
SchemaName	The name of the schema to which this cube belongs.
CubeName	The name of the cube.
DimensionUniqueName	The unique name of the dimension.
HierarchyName	The name of the hierarchy.
HierarchyUniqueName	The unique name of the hierarchy.
HierarchyGUID	The GUID of the hierarchy.
HierarchyCaption	A label or caption associated with the hierarchy.
DimensionType	The type of dimension to which this hierarchy belongs.
HierarchyCardinality.	The number of members in the hierarchy.
DefaultMember	The unique name of the default member for this hierarchy.
AllMember	The member at the highest level of rollup in the hierarchy.
Description	A meaningful description of the hierarchy.