Among the three Key Performance Indicator (KPI) reports available in CA Business Intelligence (CABI) I am able to see results only on "Level Transaction Rates of Change". How do I see results on the other two reports?

Document ID : KB000021030
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

When running the "Web Intelligence - Service Desk Application-Level Transaction Measurements" report or the "Web Intelligence - Service Desk SQL and Stored Query KPI Values" report that are part of CA Business Intelligence (CABI), there are no KPI options available for me to select. The screenshots in Figure 1 and Figure 2 below show that there are no values populated in the list of values.

Figure 1: Service Desk Application-Level Transaction Measurements

Figure 1

Figure 2: Service Desk SQL and Stored Query KPI Values

Figure 2

How do I see options available in these two reports? Clicking "Refresh Values" does not show anything.

Solution:

In order to see the options available to choose on those two reports, it is necessary to activate the KPI options in CA Service Desk Manager (SDM)

  1. The first step consists of checking if the KPI option is installed in your SDM.

    If you are able to see the "webLicenseCt" for selection on "Service Desk Application - Level Transaction Rates of Change" report, then you have it enabled.
    If you do not see an option to select for this report too, it means this option is not installed.
    To install this option, navigate to: Service Desk Administration tab -> Options Manager -> KPI -> Install the following option: kpi_ticket_data_table. Then Recycle Service Desk service so the change is recognized.

    From this point on, the License usage will be monitored by this option and you will be able to see it available for selection on the "Service Desk Application - Level Transaction Rates of Change" report. The "webLicenseCt" KPI option is enabled by default.

  2. Which KPI should be enabled?

    There are 44 disabled KPIs.

    They are distributed as follows:

    1. The "Service Desk Application-Level Transaction Rates of Change" report shows results from the following KPIs:

      virtdbGenericUserUpdateResponseDT
      virtdbOtherResponseDt
      virtdbSelectResponseDt
      virtdbTimeInBkgrdQueueDt
      virtdbTimeInQueueDt
      virtdbUpdateResponseDt
      webRequestDt

    2. The "Service Desk SQL and Stored Query KPI Values" report shows results from the following KPIs:

      bkgdRequestCt
      bpobjectActiveCt
      dbChangeNotifyMessageCt
      deleteCt
      dobActiveCt
      domsetCreatedCt
      insertCt
      lockRequestCt
      massInsertCt
      massUpdateCt
      messagReceiveCt
      messageSentCt
      normalRequestCt
      pdobActiveCt
      pslistActiveCt
      pslistCreatedCt
      rowsReturnedCt
      selectFullCt
      selectedShortCt
      Est Cost Sum of Pending Issue Workflow Tasks
      Incident SLA Count
      Issue SLA Count
      Problem SLA Count
      Request SLA Count
      Unassigned Change Orders
      Unassigned Incidents
      Unassigned Issues
      Unassigned Problems
      Unassigned Requests

  3. Enable the other KPI options on Service Desk.

    IMPORTANT:
    It is strongly recommended to enable the KPIs that you only need to use, because enabling all can cause performance issues to your Service Desk system.

    Each KPI has a description of what information it monitors in Service Desk.

    Follow these steps to activate the KPI:

    1. Login to Service Desk.

    2. Go to Administration -> Service Desk -> KPIs.

    3. Select 'Show Filter'.

    4. Choose 'Inactive' and click 'Search'.

    5. Edit the option you want to activate and click 'Activate'. Repeat this step for each item you want to activate.

    6. Recycle Service Desk.

    7. Run the reports and click "Refresh Values" in the filter if you still don't see any KPI to select.