Versions Compared

Old Version 1

changes.mady.by.user SNP

Saved on

compared with

New Version Current

changes.mady.by.user Marian Vidra

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Define a custom KPI for SQL Collector

  1. Go to the to Settings > Collector settings (or transaction /DVD/MON_COL).
  2. Select the collector /DVD/MON_CL_COL_SQL.
  3. Double-click KPI.
  4. Click New Entries (F5).
  5. Fill in all required fields for custom KPI as display in the figure. All fields descriptions can be found in (DI-2005) Define a Custom KPI.
  6. Save your KPI (CRTL CTRL + S).

Choose how data is collected into the custom KPI through a SQL SELECT statement

  1. Double-click Inputs & rules.
  2. Select Edit next to the Input table /DVD/MON_KPISQL1.

  3. Click Edit (Ctrl + F1) and then Create new records (F6). 

  4. In the next dialog enter the KPI name 'ZCUSTOM_INACTIVE_OBJECT' and fill in the SQL statement.
    The SQL Statement for inactive objects is SELECT count(*) FROM DWINACTIV WHERE deletdelete_flag <> 'X'.


  5. Save the changes (CTRL + S).

...

For information on how to schedule and start a Collector job, see see the chapter (DI-2005) Schedule the Monitoring of KPIs.

When the Collector job was executed successfully, you may display the results of your custom KPI in the main screen. For further information on how to display a KPI, see the chapter (DI-2005) Display KPIs.