The ADO MD Hierarchy object represents the way by which the members of a dimension can be structured (aggregated or rolled up) .

Basic Usage

This VBS code gets properties of Hierarchy object

Response.Write "<ul>"
For intHir = 0 To cdf1.Dimensions(1).Hierarchies.Count - 1
    Set hir1 = cdf1.Dimensions(1).Hierarchies(intHir)
    Response.Write "<li>Hierarchy: " & hir1.Name
    Response.Write "<ul>"
    Response.Write "<li>" & "Description: " & hir1.Description & "</li>"
    Response.Write "<li>" & "Name: " & hir1.Name & "</li>"
    Response.Write "<li>" & "UniqueName: " & hir1.UniqueName & "</li>"
    For i = 0 To hir1.Properties.Count - 1
        Response.Write _ 
            "<li>" & _
            hir1.Properties(i).Name & ": " & _
            hir1.Properties(i).Value & "</li>"
    Next
    Response.Write "</ul></li>"
Next
Response.Write "</ul>"

 

Object Members

Properties Collections Methods Events
  1. Descripton
  2. Name
  3. UniqueName
  1. Levels
  2. Properties
  1. (None)
  1. (None)

Here are some of the properties available through the Properties collection:

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

2007-10-10 20:03:22Z