(DI-1811) Automatic Calculation

Owned by SNP
May 02, 2018
3 min read

In this block, it is possible to define the method in which the KPI will be calculated without any coding. With customizing, you can define a new KPI (e.g. new percentage value), which will be calculated from already calculated KPIs defined in source fields. The calculation is setup in "Calculation function" field and source KPIs are defined in three fields below:

  • "KPI source for calculation"
  • "2nd KPI source for calculation "
  • "3rd KPI source for calculation".


Automatic calculation


Usage of these fields depends on the chosen calculation function. It is possible to use following calculation functions by default:

  • Minimum from all servers – new system KPI will be calculated as minimum from KPI's values of all servers defined by KPI name in first source field and are collected in current run.
  • Maximum from all servers – new system KPI will be calculated as maximum from KPI's values of all servers defined by KPI name in first source field and are collected in current run.
  • Averages from all servers - new system KPI will be calculated as average from KPI's values of all servers defined by KPI name in first source field and are collected in current run.


Example for average calculation for 
KPI DISK_RESPONS_SYS - Average disk response time (all servers)


  • Sum from all servers - new system KPI will be calculated as sum of KPI's values of all servers defined by KPI name in first source field and are collected in current run.
  • Minimum from collected KPIs - new system/server KPI will be calculated as minimum from KPI's values of all system/server defined by KPI name in first source field and are collected in current and previous runs.
  • Maximum from collected KPIs - new system/server KPI will be calculated as maximum from KPI's values of all system/server defined by KPI name in first source field and are collected in current and previous runs.
  • Average from collected KPIs - new system/server KPI will be calculated as average from KPI's values of all system/server defined by KPI name in first source field and are collected in current and previous runs.
  • Percentage from all servers - new server KPI will be calculated as percentage from KPI's values of all servers defined by KPI name in first source field and are collected in current run. Percentage is calculated from KPI's value in server as base of sum of KPI's values of all servers.
  • Percentage of one KPI from other KPI - new system/server KPI will be calculated as percentage from KPI's value of server/system defined by KPI name in first source field in current run and in base of KPI's value of server/system defined by KPI name in second source field and which are collected in current run.


Example for percentage calculation for 
KPI ENQ_ENTR_P - Usage of SAP lock table


  • Delta between last and current KPI value - new system/server KPI will be calculated as delta between KPI's value of server/system, defined by KPI name in first source field and collected in current run and previous run.
  • Absolute delta between last and current KPI value - new system/server KPI will be calculated as absolute value of delta between KPI's value of server/system defined by KPI name in first source field and collected in current run and previous run. Result KPI's value is always positive.
  • Speed of increasing of KPI value from last run in minutes - new system/server KPI will be calculated as delta between server/system KPI's value of server/system defined by KPI name in first source field and collected in current run and previous run. Result value will be divided by time between both runs.
  • Calculate difference between two KPIs - new system/server KPI will be calculated as difference between KPI's value of server/system and defined by KPI name in first source field and server/system KPI's value defined by KPI name in second source field.

The user can use the third field to facilitate the calculation of more complex KPI. Allows the users to avoid coding and to create simple calculations of KPI by only customizing/defining – how to interpret/compare values and for these to be displayed in graphical format