Creating Hierarchies
Prerequisites
In InfoObject maintenance, the hierarchy basic characteristic is set as a characteristic with Hierarchies (see Tab Page: Hierarchy).
Procedure
You can create hierarchies in two ways; either from the SAP Easy Access Menu or hierarchy maintenance in the Data Warehousing Workbench.
· On the SAP Easy Access screen, choose Modeling → Master Data Maintenance → Hierarchies. The Initial Screen Hierarchy Editing dialog box appears.
· You are in the Data Warehousing Workbench in the Modeling functional area. You can access hierarchy editing in the following ways:
¡ In the InfoObject tree, you can choose Create Hierarchy from the context menu of the required InfoObject.
¡
In the Data
Warehousing Workbench, you can call hierarchy maintenance in the
symbol bar by choosing 
Edit
Hierarchies. The Initial
Screen Hierarchy Editing dialog box appears.
Access from InfoObject Tree
1. In the Data Warehousing Workbench under Modeling, choose the InfoObject tree.
2. If you have assigned the hierarchy basic characteristic to an InfoObject catalog, select the corresponding InfoObject catalog for an InfoArea.
If the hierarchy basic characteristic does not belong to an InfoObject catalog, choose the InfoArea Non-Assigned Nodes and the InfoObject Catalog Non-Assigned Characteristics.
3. Select the characteristic for which you want to create a hierarchy and choose Create Hierarchy from the context menu. The Create Hierarchy dialog box appears. The InfoObject name appears by default.
4. Enter a hierarchy name and description (short, medium, long). Other fields may be displayed, depending on which hierarchy properties were selected for the hierarchy basic characteristic.
Fields used to enter the Validity (valid to, valid from) for the hierarchy property Total Hierarchy Time-Dependent
Fields used to specify the Hierarchy Version for the hierarchy property Hierarchies Version-Dependent.
5. Confirm your entries. The Maintain Hierarchy screen appears. You can define the structure of a hierarchy here.
6.
To create a
hierarchy node, you first need to choose an insertion mode: 
Insert as First Child or
Insert As Next Neighbor (see Hierarchy Editing
Functions).
7. Choose the type of node you want to create: Text Node, Characteristic Node, <Hierarchy Basic Characteristic Node> or Interval (see Hierarchy Nodes)
The system inserts the required node. The following symbols are used:
Nodes that cannot be posted
Text Nodes
Foreign Characteristic Nodes
Nodes that can be posted
<Hierarchy Basic Characteristic
Node>
Intervals
You can insert additional nodes in the context menu for a node. You can also call editing functions for the selected node.
8. Repeat this procedure until the hierarchy structure has been set. For more information, see Modeling Nodes and Leaves.
A hierarchy can contain 50,000-100,000 leaves at most. If your hierarchy is larger, you should insert a level that is used as a navigation attribute or preferably as a separate characteristic in the dimension table.
9. You can use Level Maintenance and Hierarchy Attributes to set how the hierarchy is to be displayed and processed in reporting (see Level Maintenance and Hierarchy Attributes).
10. Save the hierarchy.
11. Activate the hierarchy. See Editing Hierarchies.
Access Using Edit Hierarchies
...
1.
In the Data
Warehousing Workbench symbol bar, choose Edit Hierarchies. The Initial Screen: Hierarchy Editing
dialog box appears with a list of all the hierarchies in your BI system.
2. Restrict this list to the required hierarchy basic characteristic or select an existent hierarchy for it. (For more information about this dialog box, see Editing Hierarchies.)
3.
Choose 
Create Hierarchies. The Create Hierarchy dialog box appears.
The InfoObject name appears by default. The subsequent steps are the same as
those described above (4.-11.).
...
Result
The hierarchy is
activated () and can be used
in aggregates and in reporting.
See also: