Show TOC

Procedure documentationSpecifying Hierarchies Locate this document in the navigation structure

 

You can use a list of proposed values to define a characteristic as a hierarchy and insert it into the matrix. You can specify hierarchies for the following characteristics:

  • Consolidation group

  • Consolidation unit

  • Partner unit

  • FS item

  • Other characteristic, if the corresponding InfoObject has a hierarchy and the hierarchy is not disabled by role definition

Procedure

  1. 1. Place the cursor on the cell in which you want to insert the first entry in the hierarchy.

  2. Click   Data Matrix   Hierarchies   and select a characteristic.

    A dialog box opens with a list of values for the characteristic. For example, you can select a consolidation unit.

    Note Note

    If a list is very long, first, a condensed form of the list is displayed, which you can selectively expand as required.

    End of the note.

  3. Select one or more hierarchies.

    You can use the standard Windows commands to select multiple values (CTRL + click) or blocks of values (SHIFT + click). You can enter a value ID to go to its position in the list.

  4. Click Settings and determine the following:

    • Whether you want hierarchy levels to be indented when inserted into the worksheet (Format checkbox)

    • How many hierarchy levels (up to eight levels) should be expanded when the hierarchy is inserted into the worksheet

    • Whether a color should be applied to the hierarchy

    • Whether the ID and/or short text and/or long text of the characteristic should be displayed, check box ID and combobox for text types

  5. Click OK.

Result

The relevant hierarchy is inserted at the cursor position, with the specified formatting. All hierarchy entries are inserted, regardless of the number of levels that are expanded.

You can change the color format and indent of the individual levels by clicking   SAP Interactive Excel   Settings  . Your settings are saved locally on your computer.