Skip to Content

In this blog I want to introduce some Dashboard Builder features from a configuration view. In my previous blog I covered the main functionalities from an end user perspective. In the video below the following features are introduced based on SAP Solution Manager 7.2 SP05:

How to:

  • create a standard tile based on the KPI Catalog
  • define a global filter
  • define colors for characteristic values
  • define an auto-refresh
  • use a Smart View
  • jump to another application within a drill-down view
  • define thresholds

Download from KPI catalog

In the Dashboard Builder you can create standard tiles based on the KPI catalog. Within the KPI catalog you can search for standard KPI’s and filter on several criteria like application area, end-to-end process, business goal area, etc. Once you selected a KPI, the related meta data (data provider, KPI name, etc.) will automatically be taken over into the tile configuration. In case you want to change the default settings, you can still do so, e.g. if you want to change the visualization, the tile size or the fields to be used in the rows.

Global filter

In the dashboard configuration you can define global filters that are applied to all tiles and detail views within the dashboard. Within the configuration you first must choose the main data provider that should be used for the data retrieval. Then you can choose one or multiple fields from the main data source that should be used as global filter in the dashboard. These fields need to be mapped to the related fields of the other data providers that are available in the dashboard. If the data providers have the same field names, the mapping is done automatically.

For each field the select options in the end user mode can be defined. The following options are available:

  • Single value
  • Multiple single values
  • Ranges (from..to)
  • Exclude single values

It’s also possible to define default values for global filters. E.g. if you define a global filter on the field “Priority”, you can set a default filter on the value “Very high” in order to filter the dashboard on the priority “Very high” once the dashboard is opened. In addition it is possible to define dynamic filter values for the fields calendar year, quarter, month, week and day. Let’s assume you want to define a dashboard that should always be filtered on the current calendar week. Then you need to choose the calendar week as a global filter and select or directly enter the current calendar week as a default value. If you click on “Time rolling” the filter on calendar week is defined dynamically so that the dashboard is always filtered on the current calendar week.

Color configuration

Within the tile configuration you can define colors for key figures and characteristic values based on a color picker control in order to use custom colors within a chart. Instead of using the color picker control, you can also use the RGB or HSL values. If you do not specify a color, the standard SAPUI5 colors are used.

For characteristics it’s possible to define custom colors for single values and to use a specific color for all other values.

Auto-refresh

For each dashboard an auto-refresh can be defined in the configuration. The time interval can be defined in minutes. E.g. it’s possible to define a dashboard that refreshes automatically every minute.

Smart View

A Smart View is one of the templates you can use for a detail page. It provides more flexibility for end users compared to drill-down views as end users can change the drill-down, define additional filters independent of the global filter and save user-specific variants.

From configuration perspective it is possible to define the fields that should be shown initially and the default visualization (table or chart).

Jump to Application

Within a drill-down view you can define a jump to another application. For this you need to specify the target URL. You can also use URL parameter that will be added to the URL based on the selected field value. Within an ITSM dashboard you could e.g. jump from a drill-down view to the CRM Web UI using the CRM Guid as URL parameter in order to display a single Incident.

In case the URL is included in your data provider you can choose the URL type “entry-specific” and then select the field that contains the URL.

Threshold Definition

You can define thresholds for tiles in order to visualize data in different colors (red, yellow, green) depending on the threshold values. It’s possible to define different thresholds for different characteristic values or to use one threshold that is valid for all characteristic values (in that case use * in the step “Select filter & Rules template setting”). In the section “Rule template” you can select the related operators and colors you want to use.

In the 2nd step you can define then the threshold values for the selected key figure (in this case “No. of Documents”):

Prerequisites

The following steps in the SAP Solution Manager setup need to be executed in order to be able to use the Dashboard Builder in SAP Solution Manager 7.2

  • SAP BW needs to be setup (under Cross Scenario Configuration -> Mandatory Configuration -> Infrastructure Preparation – 3. Set up SAP BW)
  • SAP Gateway services need to be activated (under Cross Scenario Configuration -> Mandatory Configuration -> Infrastructure Preparation -> 7. Enable Gateway Services -> Cross Scenario Configuration)
  • BW Content needs to be activated (under Cross Scenario Configuration -> Mandatory Configuration -> Basic Configuration -> Automatic activities -> Activate BW Content for RCA)

More Information

To report this post you need to login first.

48 Comments

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

  1. Candra Prabha Pradipta

    Hi Thomas

    In order for the system/availability overview to show data on the dashboard, the UXmon require to be setup as well ?

    Currently we have finished setup for the managed system and system monitoring, however theres no data show in the dashboard.

     

    Thanks.

    (0) 
    1. Thomas Paulus Post author

       

      Hi Candra,

      please check whether data is available for the BW Query 0SMD_KPI_SYSTEM_AVAIL_OVERVIEW (e.g. via transaction rsrt). If there is no data available, please check the SAP note 2388885.

      You might also check the prerequisites under the point “Integration” mentioned in the documentation.

      As far as I know UXMon is not required to be setup.

      Best regards, Thomas

      (0) 
      1. Candra Prabha Pradipta

        Hi Thomas

        Thanks for your information.

        I have checked tcode rsrt on Solman, however there is no BW query. (I have attached the screenshot on this post)

        Besides that, the SAP note 2388885 is not applicable for our Solman (after I read it all).

        Regarding to the Integration which has mentioned in the documentation, do you have idea on where the BW info provider 0SM_DSHVP and the query 0SM_DSH_GNRC parked it to ? (System Preparation, Infrastructure Preparation or Basic Configuration).

        We just want to build a Dashboard to monitor the system performance/error/health like what technical monitoring does, does it require BW content to be activated in order to have data show on Dashboard ?

        Thanks.

         

        (0) 
        1. Thomas Paulus Post author

          Hi Candra,

          yes, you need to activate the BW content as the data is extracted into BW InfoCubes.

          In order to use the Dashboard Builder, you also have to activate some BW Content, please follow the steps described under prerequisites:

          • SAP BW needs to be setup (under Cross Scenario Configuration -> Mandatory Configuration -> Infrastructure Preparation – 3. Set up SAP BW)
          • SAP Gateway services need to be activated (under Cross Scenario Configuration -> Mandatory Configuration -> Infrastructure Preparation -> 7. Enable Gateway Services -> Cross Scenario Configuration)
          • BW Content needs to be activated (under Cross Scenario Configuration -> Mandatory Configuration -> Basic Configuration -> Automatic activities -> Activate BW Content for RCA)—> this also includes the BW info provider 0SM_DSHVP and the query 0SM_DSH_GNRC

          Please let me know in case you need further information.

          Best regards, Thomas

          (0) 
          1. Candra Prabha Pradipta

            Hi Thomas

            Thanks again for your information, its very useful.

            The SAP BW & SAP Gateway services are configured correctly with green color status. While activating BW content for RCA, there is an error shown “Deletion of data from 0CCMCURR failed with rc 2″ and after that the background job failed.

            In RSA1, I have activated & replicated the myself source system without error.

            I tried to google and checked via SAP Support portal, however there is no information about the error “Deletion of data from 0CCMCURR failed with rc 2″ do you have any idea on how to fix this error ?

            Thanks again.

             

             

            (0) 
            1. Thomas Paulus Post author

              Hi Candra,

              I checked the documentation and found that the DSO 0CCMCURR is replaced by the DSO 0CCMVAL in SAP Solution Manager 7.2. So most probably you can ignore the error message.

              Anyway if you don’t need the data in the DSO 0CCMCURR and 0CCMCURR2 anymore, you could delete the data manually in in the transaction rsa1.

              Best regards, Thomas

              (0) 
    1. Thomas Paulus Post author

      I could not reproduce the issue on our SP05 system. I asked a colleague about it and will provide an update once I have some news on it (probably next week). But in order to analyze the issue it might be required to get access to your SAP Solution Manager system. Therefore I would recommend to create an Incident.

      (0) 
      1. Jacob Tankersley

        Thank you for your effort. I already have an incident in with SAP Support, just trying to resolve this as quick as possible. If you come across anything let me know.

        Thanks

        (0) 
  2. Candra Prabha Pradipta

    Hi Thomas

    Thanks for all the replies.

    We have completed all the BW prerequisites, and the BW Content has been activated successfully.

    We facing 2 issues which are:

    1) On the Dashboard builder view, there is No Data display on the tile, its weird as apparently the data able to view once clicked in to the tile (on 2nd screenshot).

     

     

    2) The add group button is missing although the Solman_admin user is S-user and has SAP_NEW & SAP_ALL authorisation + Role: SAP_SM_DSH_CONF, SAP_SM_BI_DSH_CONF.

     

    Thanks again for your assistance.

    (0) 
    1. Terry Huang

      For the second issue, I guess your system is not SP05.

      So you can click the add tile button, then select the kpi type as “Group”

      (0) 
        1. Thomas Paulus Post author

          Concerning the first question, I would highly recommend to implement a higher Support Package (it would be best to go to SP05). For further analysis of this issue I would suggest to create an Incident so that my colleagues can check it.

          (0) 
  3. SHARAMET DENNIS

    Hi Thomas,

     

    Thank you so much for the provided guidance. This is very helpful. However I’m struggling to get the full picture about the dashboards, can you please help me with that?

    We’ve recently updated our sandbox with SolMan 7.2 SPS4. I’ve checked Dashboards Builder tool which I find great and flexible. But it looks like not all dashboards/KPIs are available in Dashboard Builder e.g. Security/Compliance Management Dashboards which are based on Configuration Validation are missing, I was not able to find KPI related to them as well as standard security related dashboards do not exist. I also can see that 7.1 Personal Dashboards still available in 7.2 with the old UI. Does it mean that we should utilize both UIs? Is it possible to get full list of dashboards which do not exist in new Dashboard Builder tool? When do you plan to sunset old UI?

    Thank you,

    Dennis

     

    (0) 
    1. Thomas Paulus Post author

      Hi Dennis,

      parts of the Dashboard Framework in SAP Solution Manager 7.1 can also be used in SAP Solution Manager 7.2. But we recommend to create new dashboards with the Dashboard Builder.

      Yes, not all dashboard content is available in the Dashboard Builder. We plan to provide additional KPI’s in the KPI catalog that can be consumed by the Dashboard Builder in the future.

      Maybe you can also consider using Focused Insights for dashboarding purposes.

      Best regards, Thomas

      (1) 
  4. Vineet Gupta

    What is the technology used by Dashboard builder. Is it a Fiori Application? or Lumira / Business Objects based tool, or BEX Web Application Designer templates or a new tool. I understand that it is using BW queries as the datasource.

     

    (0) 
    1. Thomas Paulus Post author

      The Dashboard Builder is a new tool, the dashboards are based on SAPUI5. It supports the following data sources:

      • BW Queries
      • BAdI
      • Function Module
      • Business Process Monitoring
      • Business Process Analytics

      Let me know in case you need additional information.

      (1) 
  5. Candra Prabha Pradipta

    Hi Thomas

    Its Candra here again.

    We have upgrade the Solman 7.2 to SPS 05, when clicked on the Configuration (Analytics and Dashboard) via Solman workcenter, the page does not show the screen which we have seen on SPS 00 (I attached the screenshot for example), its blank without the option for Dashboard Templates and so on..

    The Solman_admin user ID has all the roles which exist in the system, what else should we check in order to make the page back to normal ?

    Thanks.

    (0) 
    1. Thomas Paulus Post author

      Hi Candra,

      sorry for the late reply as I was on vacation. I know there were some changes regarding the required services compared to SP00. Can you please execute the following steps again the Solution Manager setup:

      • SAP Gateway services need to be activated (under Cross Scenario Configuration -> Mandatory Configuration -> Infrastructure Preparation -> 7. Enable Gateway Services -> Cross Scenario Configuration)
      • BW Content needs to be activated (under Cross Scenario Configuration -> Mandatory Configuration -> Basic Configuration -> Automatic activities -> Activate BW Content for RCA)

      Please also check the points described in the note 2388885. If the issue still persists, please create an Incident.

      Best regards, Thomas

      (0) 
      1. Candra Prabha Pradipta

        Hi Thomas

        Thanks for your help at all these while, I am able to build dashboard after implemented plenty of SAP Notes (to fix solman_setup issue on SPS 05).

        I have a question, once the tile has been built, does it able to move/shift around in the dashboard ?

         

        Thanks again for the great sharing in your blog.

         

        (0) 
        1. Thomas Paulus Post author

          Hi Candra,

          thanks, glad to hear that you could proceed with SP05. You can move/shift tiles or groups within a dashboard in the configuration mode. In the view mode for end users it’s not possible to move/shift tiles.

          Best regards, Thomas

          (1) 
  6. Vemuri MedhaDakshinaMurthy

    Thomas you put a good stuff, Nice blog and Thanks for that.

    we are on solman7.2sp04, we have configured all the required dashboards however  not able to see the Performance metric and transaction response times for few of the systems.

    Also Is there an option to actually send these OCC dashboard report via email to know about the system health status / availability etc..

    Any inputs.

    Thanks,

    Medha

    (0) 
    1. Thomas Paulus Post author

      Hi Medha,

      thanks a lot. Did you check whether the underlying data providers provide data for the performance metric and the transaction response times for the systems where no data is displayed in the dashboard? If yes, I would suggest to create an Incident on the Dashboard Builder component SV-SMG-CA-DBB so that my colleagues can analyze the issue.

      Currently it is only possible to copy and send the link if you want to share a dashboard with other users via email. What would be the requirement from your side, would you like to send a screenshot of the dashboard per email?

      Thanks and regards, Thomas

      (0) 
  7. Vemuri MedhaDakshinaMurthy

    Hi Thomas,

    Able to figure out what i have missed and now that the performance and transaction response metric looks good in the dashboard.

    I now added the few other systems in to tactical dashboard and could not able to see the correct data for System Availability and Database Growth.

    Thanks for the component code, created the incident.

    I would like to send the health status report to my management with out any manual effort , how do i achieve to send the screenshot of the dashboard via email in regular intervals.

    Regards,

    Medha

    (0) 
    1. Thomas Paulus Post author

      Hi Medha,

      within the Dashboard Builder it’s unfortunately currently not possible to send screenshots by mail in regular invervals. But I will take this as a requirement and check whether it can be provided in a later SP.

      Best regards, Thomas

      (0) 
  8. Candra Prabha Pradipta

    Hi Thomas

    May I inquiry that whether the dashboard can be clicked/displayed on mobile device, by accessing to the solman_workcenter url ?

    Or does it require to use the Fiori mobile app to instead ?

    We are unable to test it at the moment, as the server is connected to our office network, and it has block the incoming access from outside & outgoing access to outside.

    Thanks.

    (0) 
    1. Thomas Paulus Post author

      Hi Candra,

      in the end user mode you can use the dashboards also on tablet devices. You can call the dashboards via the SAP Solution Manager launchpad. The dashboards are responsive, but I would recommend to use it only on tablet devices, not on mobile phones (especially for the detail views). The configuration mode is only fully supported on desktop devices.

      But you need to be connected to your office network (e.g. via VPN) in order to use the SAP Solution Manager Launchpad and the dashboards created with the Dashboard Builder.

      Best regards, Thomas

      (1) 
  9. Candra Prabha Pradipta

    Hi Thomas

    I have found out that the data on the dashboard is not live, and its stop updating now, error in the screenshot below:

     

     

    Do you have any idea on how to fix it ?

    We checked that the prerequisites below is done and no issue.

    • SAP BW needs to be setup (under Cross Scenario Configuration -> Mandatory Configuration -> Infrastructure Preparation – 3. Set up SAP BW)
    • SAP Gateway services need to be activated (under Cross Scenario Configuration -> Mandatory Configuration -> Infrastructure Preparation -> 7. Enable Gateway Services -> Cross Scenario Configuration)
    • BW Content needs to be activated (under Cross Scenario Configuration -> Mandatory Configuration -> Basic Configuration -> Automatic activities -> Activate BW Content for RCA)—> this also includes the BW info provider 0SM_DSHVP and the query 0SM_DSH_GNRC

    Thanks.

    (0) 
    1. Thomas Paulus Post author

      Hi Candra,

      this could have different reasons.  You might find some additional information on the error message in the gateway log (transaction /IWFND/ERROR_LOG). You can restrict the error log on the service name “AGS_DSH_KPI_DATA_SRV”.

      In case you cannot identify the issue, I would suggest to create an Incident on component SV-SMG-CA-DBB so that my colleagues can analyze the issue.

      Best regards, Thomas

      (1) 
  10. Soporte Enterprise Support

    Hi Thomas:

     

    First, I’d like to thank you for useful post.

    We are working with the dashboard builder to create some tiles for IT Service Management, we have created a copy of SAP Standard “IT Service Management Analytics tile” and start editing it to adjust details such as type of tile, columns, timeframes and so forth.

    We released the tile for the reporters or end users with role ZSOLMANREQU but we found an issue: those users are able to see all the incidents of the company and not only the created by them (as should be).

    So, we’d like to ask you: Do you know how can we add filters to the queries? How can we restrict what users see on these dashboards?

    Thanks for your time,

    Ricardo

    (0) 
    1. Thomas Paulus Post author

      Hi Ricardo,

      thanks a lot. If the reporters should only see the Incidents created by them, you have 2 options. You can create a customer exit variable to replace the reporter (InfoObject 0SPRREPTER) by the user  that is currently logged on. In the SAP NetWeaver Business Warehouse wiki you can find some information on how to create a customer exit varibale. In the include you can replace the variable by the system user (l_s_range-low = sy-user).

      Let me know in case you have questions to that.

      You might also check the BW Analysis authorizations in order to restrict what users see on the dashboards.

      Best regards,Thomas

      (0) 
  11. Keith Wayne Wong

    Dear Thomas,

     

    When creating the custom tiles in dashboard builder, Business Process Monitoring is not listed as a data source type. Only Function module, Business add-in, BW Query and BPA is available. Is this an intended change to force customers using BPA or possibly a bug?

    We are running on SOL 7.2 SP05 and the latest ST-CONT. Thanks

    Best Regards,

    Keith

     

     

    (0) 
    1. Thomas Paulus Post author

      Dear Keith,

      Business Process Monitoring should be listed as data source type. There was no change. In the Dashboard Builder configuration you should see the following options:

      In case the option “Business Process Monitoring” is not available, it’s possibly a bug and I would suggest to create an Incident.

      Best regards, Thomas

      (0) 
      1. Keith Wayne Wong

        Dear Thomas,

         

        Yes, looks like a bug to me as BPM is not an available option. Raised an OSS message but still waiting for a fix.

        Will update the community here later on in case anybody else runs into this.

        Best Regards,

        Keith

        (0) 
  12. Sanjay Raut

    Hi,

     

    I am implementing Dashboard in the SP05 version. I wanted to one tile in which I can see the Abap Dumps data but In the KPI catalogue there is list of fields which needs to be configured. I don’t know where I can find the list and all.

     

    I have attached the screenshot for the reference.

     

    Please guide me on this.

    Thanks!

    (0) 
    1. Thomas Paulus Post author

      Hi,

      the KPI “Number of ABAP dumps (per Day) belongs to Business Process Analytics. So it’s a prerequisite to have Business Process Analytics set up correctly. If you take over the KPI in the Dashboard Builder you can configure the fields described in the KPI documentation, e.g.:

       

       

      If you don’t use Business Process Analytics, you might check the InfoProvider 0SMD_EA1D. It needs to be restricted on the metric type = ABAP_Dumps.

      You might also refer to the BW Query 0E2EREP_ALLSYS_ABAPERRORSJ_D for the definition. Please note that this query cannot be used directly in the Dashboard Builder as it has mandatory variables. But you could copy it and adapt it to your needs.

      Please let me know in case of additional questions.

      Best regards, Thomas

      (0) 
      1. Sanjay Raut

        Hi Thomas,

         

        Thank you for your reply!

         

        Right now in our system, Business process Analytics is not configured. So I think we will have to go with the InfoProvider 0SMD_EA1D.

        But I had one more doubt, as of now, in Calenday Day and Calender Year/Week filters, we are manually entering values to display the data.

        Is there any way that I can dynamically set the value in the format that it should show display the data for previous week(45) and current week(46) then again in next week, the data shown should be like previous week(46) and the current week(47).

         

        Let me know in case of any issues!

         

        Thanks in advance!

        (0) 
        1. Thomas Paulus Post author

          Hi Sanjay,

          yes, you can dynamically set the value for the main time characteristics like calendar day or calender week. You first need to set the current calendar week values (e.g. 45.2017 and 46.2017 for the previous and this week). In the filter area you can define then by clicking on the “time rolling” icon whether the filter should be applied dynamically. I also prepared a screenshot for it:

          This is supported in the tile configuration as well as in the Global filter definition. You can find the information also in the SAP Help Portal:

          If the field for which you create a filter is a time value, you can choose between Static Value (the filter period always remains the same) and Time Window Rolling Pattern (the filter period shifts so that the relative time difference to the present remains unchanged). To switch between these two settings, choose the corresponding pushbutton on the Filter subscreen.

          Hope this information helps. In case of additional questions, please get back to me.

          Best regards, Thomas

          (0) 
          1. Sanjay Raut

            Hi Thomas,

             

            Thank you for such great information.

             

            We could use the filters in our dashboard and able to dynamically set the value.

             

            However I have one more thing to ask is how we can apply standard KPI to report IDOC errors, qRFC errors and tRFC errors on dashboard.

             

            Thanks in advance!

             

             

            (0) 
            1. Thomas Paulus Post author

              Hi Sanjay,

              I think some metrics related to IDOC errors, qRFC errors and tRFC errors are also included in the InfoProvider 0SMD_ME1H. These metrics are related to Interface and Connection monitoring.

              You can also check the available metrics for Monitoring and Alerting via the transaction MAI_TOOLS -> Expert Mode -> Configuration

              There you find the technical name of the metric which you can use in the InfoProvider 0SMD_ME1H in order to restrict on the field metric type.

              Maybe you can check for IDOC errors the metric ICMON_IFCHANNEL_IDOC_NO_IDOC_EXCEPTIONS_TOTAL whether data is available using the InfoProvider 0SMD_ME1H.

              Best regards, Thomas

               

              (0) 

Leave a Reply