Focused Insights OCC Dashboard – ITSM Data Provider: Switch to SAP CRM BOL that reliably reflects CRM WebUI Client search results

The KPI Number of Tickets For ITSM Transactions of the ITSM Data Provider suits for most of the use cases when you want to count the number of tickets. This KPI should be your No.1 choice as it combines the capabilities of many other KPIs with the name “Number of…” yet it cannot replace those which are dealing with time values (Average Processing Time etc.).

Focused%20Insights%20dashboards%20with%20reliable%20data

Focused Insights dashboards with IRT and MPT ticket data

In general, the ITSM Data Provider works very well. However, for IRT (Initial Response Time) and MPT (Maximum Process Time) you will encounter a mismatch between the number of tickets you get displayed in the CRM WebUI Client and the Focused Insights dashboard. While the search retrieves the correct number (in this example 9), the dashboard shows zero.

CRM%20WebUI%20Client%20-%20search%20for%20Service%20Requests%20with%20MPT%20exceeded

CRM WebUI Client – search for Service Requests with MPT exceeded

Focused%20Insights%20dashboard%20with%20no%20data%20for%20MPT%20exceeded

Focused Insights dashboard with no data for MPT exceeded

Taking a closer look, we can prove that for “common” statuses like In Process or Confirmed we get the expected results, while for MPT Exceeded (as well as for IRT and warnings) it does not work.

xxx

DP ITSM: KPI “Number of Tickets For ITSM Transactions”

xxx

Ticket status “In Process” and “Confirmed”: data is displayed

xxx

Ticket status “MPT Exceeded”: no data displayed

The good news… SAP provides a new way to get this data in Focused Insights dashboards 😊

SAP Note 3107002 – DP_ITSM filters not working for KPI – Number of Tickets for ITSM Transactions provides a “switch” to change the data source from BW Cubes to SAP CRM BOL (Business Object Layer) Query.

The very good news… you can do this even if you have dashboards created before (I had hundreds of them) without losing any data or damaging your existing dashboards.

Read and follow the instructions carefully! Although there are no manual activities mentioned in the note header, after implementing the code corrections you must run a report for adapting the settings, otherwise it takes no effect.

SAP%20Note%203107002

SAP Note 3107002

Execute the report /STDF/FI_SETUP_PARAMS (TCode SA38) and activate [X] the SWITCH. Furthermore, maintain the parameter DPITSM_MAX (see the note instructions for details). Execute for saving the data.

Report%20/STDF/FI_SETUP_PARAMS

Report /STDF/FI_SETUP_PARAMS

Switch%20activation

Switch activation

Reload your Focused Insights dashboard. Now it works!

xxx

Focused Insights dashboard with data for MPT exceeded

Once you have switched to SAP CRM BOL Query, you will find an additional “Date” tab in the query settings. When fetching the data from BW Cubes, you always get the “creation date” displayed.

xxx

CRM WebUI Client – search for Service Requests with status “Confirmed”

xxx

BW Cubes: Always the creation date

xxx

SAP CRM BOL Query: Creation date

xxx

SAP CRM BOL Query: Last change date

In a nutshell:

SWITCH = [X]  >>  SAP CRM BOL Query
SWITCH = [  ]  >>  BW Cubes

It’s that simple, so give it a try. I haven’t had any disadvantages since I switched. In case you do, please leave a comment. In case you like the switch, feel free to like this blog post. By the way, the switch is reversible.

All screenshots were taken by me in SAP Solution Manager 7.2 SPS11 with ST-OST 200 SP06 and the latest SAP Notes implemented.

PS: The more I use the word switch, the more I like it 😉