(DI-1904) KPI Details Displayed in a Detail Table

Owned by SNP
Last updated: May 20, 2019
4 min read

A Detail table is a specific table of a collector, which contains further information of a KPI. This information is useful for interpretation of a KPI, as the KPI value is only a number and in some cases you need more details about it.
For example, if a KPI collecting the number of failed BG jobs has the value 3, then you can find in the Detail table for BG jobs names of those 3 jobs with their run-times, schedule times, reason of failure and other information.

Not all KPIs have a possibility to display further information in a Detail table. To check whether a KPI includes a Detail table, proceed as described in Display a Detail table of a specific KPI.

Detail tables can't be adjusted for default KPIs or for custom KPIs assigned to a Collectors with a Custom KPI.
You may create you own Detail table only for custom KPIs assigned to the (DI-1904) Custom Collectors and the Collector for user defined SQL. Please see a description on how to create a Detail table, in the chapter (DI-1904) Create a Detail Table for a Custom KPI Assigned to a Custom Collector and (DI-1904) Create a Detail Table for a Custom KPI Assigned to the Collector for a User Defined SQL

Display a Detail table of a specific KPI 

There are two possibilities how to display a Detail table for a KPI:

If a Detail table isn't displayed, then the collector associated with the KPI doesn't include a Detail table. 

  • The first option:
  1. You may narrow your search by selecting a particular system and a server for which the KPI is displayed (1) and by specifying a time interval (2).

  2. Then, select a KPI in the KPI groups and with a righ-click display a context menu (3) (see the figure below). The context menu contains all the versions of Detail tables with relevant systems based on this selection.

    A Detail table may have more versions. The reason for a newer version of a default Detail table is an update of Insights or the monitoring of more satellite systems, which have a different Insights version. In this case you should choose the last version of a Detail table.
    A newer version of a custom Detail table is also created, if you change the data structure of a Detail table. This occurs only when you create your custom collector with a Detail table.

  • The second option is: 
  1. Select a KPI in the KPI groups and click on the KPI charts tab.
  2. Then, right-click at a point in the KPI chart. If the KPI has assigned a Detail table, then the Detail table is displayed.


When you click on a particular version of a Detail table, you may view in the header all the selected systems on which the assigned KPI is monitored. In the case you haven chose a server in System landscape, then the title "Detail table is server dependent" appears above the table.

A Detail table for a server dependent KPI is displayed only, when you selected a specific server in System landscape.

The SAP ALV grid can't display more than 128 characters in one column. If the columns of a Detail table contain more characters, then the value is shortened.
If you want to display the complete value, click Export to download records in the original size.


You can find list of all available Detail tables on the Details tab.

If you select a Detail table and its data isn't displayed, these two situations could occur:

  • The monitoring of the KPI assigned to this Detail table wasn't started
    The message Data weren't collected yet for a Detail table appears. In this case you should schedule the monitoring of the KPI assigned to the Detail table, as described in (DI-1904) Schedule the Monitoring of KPIs.
  • The KPI assigned to this Detail table is collected on different servers and systems and in an other time, as the one which is chosen in the main screen.
    The message No data exist for selected SIDs and time period appears
    In this case you should select the system or server and set a time interval in which the KPI assigned to this Detail table was collected.

To check which KPI belongs to a specific Detail table:

  1. Go to Settings > Monitoring settings.
  2. Select a KPI under KPI definitions.
  3. Double-click Assigned details.

Create a custom Detail table

You may create you own Detail table only for custom KPIs assigned to the (DI-1904) Custom Collectors and the Collector for user defined SQL. Please see a description on how to create a Detail table, in the chapter (DI-1904) Create a Detail Table for a Custom KPI Assigned to a Custom Collector and (DI-1904) Create a Detail Table for a Custom KPI Assigned to the Collector for a User Defined SQL