(DI-1808) Collector for Calculation

The calculation collector is named: /DVD/MON_CA_CL_COL_CALC

Collector collects KPIs with defined calculation function of input table. The KPIs are defined via KPI definition and input table /DVD/MON_CA_KDEF.

Input table /DVD/MON_CA_KDEF sets up calculation function for KPI. Input table has following fields:

KPI name	Same technical name like in KPI definition
Function	Calculation function
Changed by	Last change by user [automatically filled]
Changed at	Last change date and time [automatically filled]
Created by	Created by user [automatically filled]
Created at	Created date and time [automatically filled]

Functions for calculations

KPI() – Function KPI() returns collected values of KPI in time range.

Parameters: only one KPI

AVG() – Calculates average of values.

MAX() – Selects the maximum value.

MIN() – Selects the minimum value.

SUM() – Function sum all values.

DIFF() – Function subtract all values.

MUL() – Multiplication of all values.

DIV() – Dividing of all values.

Parameters for functions above:

only one KPI
more constant values
more functions
combination of constants and functions

Examples

KPI(DB_CPU_LOAD5_P) – returns all values in time range

MAX(KPI(DB_CPU_LOAD5_P)) – gets maximum of values from KPI

MAX(MAX(KPI(DB_CPU_LOAD5_P)), 60) – gets maximum of two values,

- first parameter is MAX(KPI(DB_CPU_LOAD5_P))

- and second is threshold – 60

DIV(MAX(MAX(KPI(DB_CPU_LOAD5_P)), 60), 60) – divides maximum from

- function MAX(MAX(KPI(DB_CPU_LOAD5_P)), 60)

- and threshold – 60

Example of input table

KPI name	Function
CF_THRESHOLD	DIV(MAX(MAX(KPI(DB_CPU_LOAD5_P)), 90), 90)
ZCALC_FUNCTION	MAX(KPI(CPU_IDLE))

Some KPIs are provided in standard delivery with collector as examples:

KPI name	Description	Unit
CF_THRESHOLD	Value relative to threshold of KPI	count

Step by step to define KPI:

Create KPI definition
Define function in input table