Dashboard Builder

For creating and displaying dashboards, SAP provides the Dashboard Builder as standard in SAP Solution Manager 7.2. The Dashboard Builder is a Browser-based tool that enables you to quickly create tile-based dashboards in order to visualize data for analysis. In this blog I want to describe the features from an end user perspective.

In the following video you get a high-level overview of the Dashboard Builder:

Dashboard Overview

The following picture shows an example of a dashboard in the area of Application Operations:

Within the dashboard you can filter on the systems you are interested in as well as on the time frame. The filters can be accessed via the filter icon in the header.

You can also enlarge the charts by clicking on the magnifier-icon in the upper right corner of the tiles:

Detail page

If you want to analyze further, you can click on a tile to get to the detail page. You can also click on a bar within the chart area in order to analyze a specific system that you are interested in:

Within the detail view you can add or remove fields and key figures and also change the visualization. It’s also possible to export the result to MS Excel and to save user-specific variants.

You can also define another layout for the detail page called Drill-Down views. This page includes associated KPI’s (optional) that are displayed in the header and one or multiple drill-down views that can be displayed as chart or as table:

Within the Drill-Down views you can also export the data to MS Excel.

Data sources

It is possible to select predefined KPI’s from the KPI Catalog or to choose custom-specific data sources in order to create visualizations in the Dashboard Builder. The following data source types are available in the configuration mode:

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

The following picture shows the selection of a KPI from the KPI Catalog:

Dashboard Best Practices with SAP Solution Manager 7.2

In the blog from Xavier Dupeyrat you can find some information about the 2 solutions SAP offers to create and display powerful dashboards for the IT and the business: Dashboard Builder and Focused Insights for SAP Solution Manager.

More Information

To report this post you need to login first.

8 Comments

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

  1. Nisha Nemade

     

     

    Hello Thomas,

    Thank you for sharing.

    Could you also please share the features/reports of Dashboard Builder which replace the Alert Management Reporting area (which exists in Solution Manager 7.1) ?

    OR

    Please share SAP Notes / links on how dashboards can be build in Dashboard Builder based on systems (an not based on alerts as you have shown above).

    Best Regards

    Nisha

    (0) 
    1. Thomas Paulus Post author

      Hello Nisha,

      please check the tile “Alert Reporting” under the group “System and Application Monitoring” in the SAP Solution Manager Launchpad. To start the launchpad, just call transaction “SM_WORKCENTER”.

      Best regards, Thomas

      (0) 
  2. Matias Prado

    Hi Thomas Paulus.

    Thanks for your blog.

    Where can I get the Unplanned Unavailability dashboard? , Or the Data Provider you use to create the dashboard.

    Could you tell me your contact email?

    Kind Regards.
    Matias Prado

     

    (0) 
    1. Thomas Paulus Post author

      Hi Mathias,

      there is no separate entry for this dashboard in the SAP Solution Manager Launchpad. But you can access the Dashboard Builder via the tile “Configuration – Dashboards and Analytics” within the SAP Solution Manager Launchpad. Within the Dashboard Builder the dashboard “Availability Overview” can be found under the category “Application Operations”. From within the dashboard you could get the URL to open the dashboard via URL in the end user mode. This could be used e.g. to integrate it as a separate tile in the SAP Solution Manager Launchpad.

      The Data Provider and the key figures are also described in the KPI catalog. The technical name of the BW Query that is used in the dashboard is 0SMD_KPI_ABAP_AVAIL_LIST.

      Let me know in case you have more questions.

      Best regards, Thomas

      (1) 
  3. Matias Prado

    Hi Thomas,

    My question is about the dashboard “unplanned unavailability”, because I can not find the KPI associated with this application.

     

     

    Kind Regards.

    Matias Prado

     

    (0) 
    1. Thomas Paulus Post author

      Hi Mathias,

      the KPI is based on the key figure “Unplanned Unavailable (%)” in the BW query 0SMD_KPI_ABAP_AVAIL_LIST (0CCMPDATA):

      In the tile “ABAP – Unplanned Unavailability” the BW query 0SMD_KPI_ABAP_AVAIL_LIST  is filtered on the key figure “Unplanned Unavailable (%)”:

      Let me know in case you have any additional question.

      Best regards, Thomas

      (1) 
  4. Matias Prado

    Hi Thomas,

     

    Thank you very much for your help.

    Create the dashboard, but I would like to know how to modify the colors of the dashboard.

     

    Kind Regards.

    Matias Prado

    (0) 
    1. Thomas Paulus Post author

      Hi Mathias,

      the feature to modify colors for characteristics of key figure is currently planned for SAP Solution Manager 7.2 SP05. I will soon write a blog with more information about the SP05 features.

      At the moment you could use thresholds to get a red color in that case. You can do this in the configuration via right mouse click on the key figure structure:

      Then enter * under system in order to define the threshold for all systems and click on the green checkmark:

      In the last step you can define the threshold, e.g. Red if greater than or equal to 0:

      Best regards, Thomas

      (0) 

Leave a Reply