Skip to Content

I had been trying to get this to work for a while, forgot about it, then tried it again yesterday when I was doing my daily Solution Manager tasks.

Prerequisite: BEx Query 0SPR_WORKLOAD_OF_MESSAGES must be activated; it was not activated in my system so as a result it was never working for me.  To activate, go to RSA1 and follow the normal steps to activate in BW.

Next, under the SM_CRM transaction, select ITSM BW Dashboard.

/wp-content/uploads/2013/07/1fig_241923.png

In the upper right corner, select Add New App

/wp-content/uploads/2013/07/2figaddnewapp_241924.png

Select ITSM Workload app

/wp-content/uploads/2013/07/2selectworkload_241934.png

Then a wizard will walk you through the steps, asking you the transaction types to display.

/wp-content/uploads/2013/07/4fig_241935.png

I selected two transaction types.

/wp-content/uploads/2013/07/5fig_241936.png

This is how it looks:

/wp-content/uploads/2013/07/6sample_241937.png

So the hardest part and the stumbling block was getting the BEx query activated – other than that, everything else was very simple.

To report this post you need to login first.

3 Comments

You must be Logged on to comment or reply to a post.

  1. Rob Kading

    Hi Tammy

    I managed to get this working, but performance is terrible. Do you know how to improve the response time of this dashboard? It takes about half an hour to refresh my dashboard 🙁

    Regards

    Rob

    (0) 
    1. Tammy Powlas Post author

      Rob – I am only using this against small amounts of data; best recommendation is to run RSRT transaction against 0SPR_WORKLOAD_OF_MESSAGES query and see the performance there.

      If performance is good, then I recommend either posting on the SCN forums so other experts can offer advice or open a ticket with SAP support.

      Regards,

      Tammy

      (0) 
      1. Rob Kading

        Thanks for the fast response, Tammy

        Now I get “An error has occurred while trying to execute BW query 0SPR_WORKLOAD_OF_MESSAGES” and my systems seems to have gone totally unresponsive (even RSRT renders no result).

        Looks like I’ll have to open a ticket.

        Regards

        Rob

        (0) 

Leave a Reply