Start of Content Area

 Procedure documentation Creating Hierarchies  Locate the document in its SAP Library structure

Prerequisites

The hierarchy basic characteristic is indicated as a characteristic with Hierarchies in InfoObject maintenance (see Tab Page: Hierarchy)

Procedure

You can create hierarchies in two ways: Either from the SAP Easy Access Menu or via hierarchy maintenance in the Administrator Workbench.

        From the SAP Easy Access Menu, choose Modeling Master Data Maintenance Hierarchies. The Initial Screen Hierarchy Editing dialog box appears.

        You are in the Modelingfunction area of the Administrator Workbench. 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.

        You can call up hierarchy maintenance via This graphic is explained in the accompanying text Edit Hierarchies from the symbol bar in the Administrator Workbench. The Initial Screen Hierarchy Editing dialog box appears.

Access via InfoObject tree

       1.      In the Administrator 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.

Example

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: This graphic is explained in the accompanying text Insert as First Child or This graphic is explained in the accompanying text Insert As Next Neighbor (see Functions of Hierarchy Processing).

       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 can not be posted

This graphic is explained in the accompanying text Text Nodes

This graphic is explained in the accompanying text Foreign Characteristic Nodes

Nodes that can be posted

This graphic is explained in the accompanying text <Hierarchy Basic Characteristic Node>

This graphic is explained in the accompanying text Intervals

You can insert additional nodes via the context menu for a node. From here, you can also call up editing functions for the selected node.

       8.      Repeat this procedure until the hierarchy structure has been set. You can find additional information under Modeling Nodes and Leaves.

Recommendation

A hierarchy can contain 50,000-100,000 leaves at the 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 via Edit Hierarchies

...

       1.      Choose This graphic is explained in the accompanying text Edit Hierarchies from the Administrator Workbench symbol bar. The Initial Screen: Hierarchy Editing appears with a list of all hierarchies in your BW system.

       2.      Restrict this list to the required hierarchy basic characteristic or select an extant hierarchy for it. (You can find additional information about this dialog box under Editing Hierarchies.)

       3.      Choose This graphic is explained in the accompanying text 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 (This graphic is explained in the accompanying text) and can be used in aggregates and in Reporting.

 

See also:

 

Modeling Nodes and Leaves

Editing Hierarchies

Hierarchy Editing Functions

 

End of Content Area