Show TOC

 Displaying Key Figures Matrix

Use

The distribution of values of a key figure of two different characteristics is in the key figure matrix.

If, for example, you want distribute the material stock level to different plants for comparison then you can call the key figure Total stock for the characteristic material and plant.

This function is available as of Release 4.5 in the standard analysis of the self-defined info structures of the type C, E, and F and in some standard analysis of the application Retailing.

Procedure

If you wish to display a key figure matrix, proceed as follows:

  1. Call the standard analysis for self-defined information structures.

  2. You can now drill down by double-clicking on the characteristic.

  3. Drill down the initial list to the characteristic that you need for the analysis and position the cursor on the required key figure.

  4. Choose: Start of the navigation path View Next navigation step Key Figure Matrix End of the navigation path

  5. The Characteristics for Key Figure Matrix window appears. Highlight another characteristic in the list and confirm it.

    You can only select characteristics that are not in the drilldown path.

    If you have not highlighted a key figure, a window appears automatically after selecting the characteristic for you to select a key figure.

  6. You now branch to the key figure matrix. The selected characteristics are then displayed above one another. The description of the key figure that relates to the characteristic is above the table.

    The characteristic with the most instances is displayed line by line (left column), the other is in columns.

    The matrix also has line and column addition.

Note Note

In the key figure matrix different currencies are not displayed individually like in the standard analysis. This can be set up before calling the key figure matrix (Start of the navigation path Settings Next navigation step Currency Next navigation step Analysis currency End of the navigation path). If you do not enter one, it is displayed with ***, meaning it is invalid.

This ensures consistent currency display.

The Column width is changed to match the output documents of the largest key figure value and the header length is changed as well.

The list can only be 1023 characters long. If the list is too long a dialog box appears informing you of this and error indicates the problem.

When you need an analysis as large as this you can select the characteristics that are already in the standard analysis and limit it with these and the call each standard analysis individually.

Save the file by choosing Start of the navigation path Key Figure Matrix Next navigation step Save to PC file End of the navigation path.

You can read more about the function (Start of the navigation path Edit Next navigation step Abs Next navigation step Proc End of the navigation path) under Setting Up Value Display.

Click on a value to display all key figures for this characteristic combination (same is in the standard analysis).

You can also change the matrix without returning to the initial list (Goto -> New key figure). This list only contains the key figures you selected before.

You can also use Start of the navigation path Goto Next navigation step All key figures End of the navigation path, to access all the key figures of the info structure, depending on the restrictions in the initial list.

You can also display the key figure matrix as a graphic. You can only display 32 characteristics at a time. A dialog box appears if you try to display more.

End of the note.