Creating and updating a hierarchy

      A hierarchy represents the logical relations among attributes. A typical example is the date hierarchy. A date belongs to one month and  month has more dates (1:n relation). Accordingly, the next date relations among month, quarter and year. 

The Hierarchy tool allows you to place two attributes into a hierarchy (Parent-Child) relationship.  Simply drag the parent attribute into the parent location, and the child attribute beneath it.  You can create multi-level hierarchies as well by using the child attribute of one hierarchy as the parent of another.  These relationships will be displayed as a horizontal row in the data model with the highest level of the hierarchy to the left, and lowest level, to the right. 

Figure 16 shows an example of a naturally-occuring hierarchy, a calendar/date hierarchy.

You can create a new hierarchy among the loaded attributes:

1. Click on the ldm tab.
2. Click on the Hierarchy Panel in the Right Properties Type Menu to open the Hierarchy panel.
3. In the left menu, click on attributes to open the Attributes panel. Select the attribute (not the  and Drag it to be used for the join to the From Object section of the Hierarchy panel and drop it there.

The result view after the Join is shown here:

To remove or reverse a hierarchy, select any of its elements, then use the Break button.