Skip to Content
Introduction Did you tired of trying to make a decision from endless rows and columns of data with tabular reporting, are you looking for a board that has all summarized information at higher level and showed them in awesome layout with beautiful colors,easy to memorize the numbers/colors on fingers , how the business is doing at any given moment. When we look at the all organization measures how they are performing with helicopter view, we need a report that teaches and shows the trend in a graphical display quickly. These reports are called as Dashboard Reports, still we can report these measures individually, but by keeping all measures in a single page, we are creating single access point to the users to view all information available to them. Absolutely this will save lot of precious time, gives clarity on decision that needs to be taken, helps the users to understand the measure(s) trend with business flow. Dashboard Reporting became more popular because of single view on multiple measures, these reports are more helpful for managers, business analysts, and corporate decision makers. Now a days Dashboard Reporting became as backbone to management level reporting. For users who need to continuously monitor corporate performance across business functions and organizations levels, SAP offers visually intuitive dashboards. Dashboards allow quick assessment of business conditions and highlights issues requiring further investigation or action. Dashboard Advantages (1) Multiple measures in single graphical view (scorecard view etc) (2) Communicate information more effectively. (3) Gain greater insight into your business data. (4) Persuade your audience. (5) Find a root cause. (Drill down /across /jump into info set) (6) Build a graphical dependency between measures (business flow) (7) Trend a measure(s) over period of months. (8) Share your dashboards (broadcast) Level of Detail Usually Dashboard metrics are defined at the higher level with composite/sequential business process that shows the summarized numbers. Most of the dashboard reports were multi provider reports where we can have single view across multiple KPIs. Detail level information can be obtained with jump queries to infoset Dashboard Reporting Types (1) Interactive Dashboard Reports (Multidimensional reports) (2) Formatted Dashboard Reports (Fixed rows / columns) Interactive Dashboard reports allows the user to browse the information as much detail by changing the views and drilldowns and drill across.This report is highly navigatable across different business entities. We can able to change the selection parameters and choose the different variant that you like to view the information required. Formatted Dashboard Reports are predefined structured reports that have limited navigation. These reports won’t allow the users to change predefined default view, helpful for PDF reporting (or) Scorecards. Creation of Dashboard in SAP BW A Dashboard is a web page built in a web template by using web application designer. Most of these web templates have one or more table grids with different charts available in Web Application designer to present the information in graphical format. Steps-by-step procedure to create a Dashboard: – (1) Create all BEx Queries with required variants,tune them perfectly. (2) Differentiate table queries and graph queries. (3) Choose the graph type required that meet your requirement. (4) Draw the layout how the Dashboard page looks like. (5) Create a web template that has navigational block / selection information. (6) Keep navigational block fields are common across the measures. (7) Include the relevant web items into web template. (8) Deploy the URL/Iview to users through portal/intranet. Dashboards in Visual Composer :- Couple of more graphical (new chart types) and browsing features available with visual composer ,please read/stay tune with SDN for upcoming documents. Dashboard Report – Example image Note: Screens shown above is a general Dashboard view.
To report this post you need to login first.


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

  1. Former Member
    I’d like to add the following:
    – Take lots of time to match query and chart accordingly. From my experience the worst thing you can do is to say: All queries are displayed with charts/pies/etc. Take the time and look at each query and each chart as if it’s the first chart.


  2. Former Member

    This is a breat thread and lot of my clients are moving towards this. Let us discuss pros and cons of this. One of the main challenge which we face is to get the right matrices or parameters for these Dashboards. Do you have any templates, information you can share on this.
    I have used HR Dashboard in successfully in many cases but we needed to do a lot of customization on web templates to make it look better. Hope it is better in 70 enviroment.

    1. Former Member Post author
      Hi Pramod,

      In beginning its better to develop a dashboard with couple of common metrics available,then start inventing few more though, that’s an ongoing process.

      As we aware we can define a metric by combining two metrics (or) split one metric into two metrics, its all depends on how we look at the information available, are we looking at root cause (or) overview.

      Moreover am releasing part 2 for this blog in few days that has more business overview,show some tricks to define a new metric as well that we need to focus.

      There are couple white papers available in market for predefined metrics / can find some in SAP (not much).

      Yes Pramod, I agree It’s a challenge to invent a metric for dashboard, a good metric will bring audience and value for dashboard ,Business experts can define this metrics in a seconds as per my experience.

      Good Luck , keep in touch.

      Thank you

  3. Former Member
    Thanks for sharing such a vital information.

    Requesting to kindly let us know the procedure to  get speedometer shown in your blog in Visual Composer…


  4. Former Member
    I’ve developed and use several dashboards with lots of drilldownthey look great but do have performance issues, speed is very slow, and Ive not yet found what if anything can help, except to have higher level info or no drilldown and precalc.

Leave a Reply