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.

28 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) 

Leave a Reply