Screen shots of the “LAVA demo”

photo 6.PNG

photo 5.PNG

How to make an overlay of Bar Charts with SAP Dashboard:

You can download an .xlf “Overlay of Bar charts” that you can look at here https://drive.google.com/file/d/0B_485EXXLdAfSkpRZERiTmZfUVk/edit?usp=sharing

This is how we did it:

  1. For the two charts:
  • Don’t show all the text content, just uncheck all the boxes.

how to 1.png

  • Disable all the Axis, make sure all the boxes unchecked.

how to 2.png

  • Make them have strict scale: you could verify this by showing the Vertical Axis Labels. It is extremely important to do this for it to appear right.

how to 3.png

2. For the background bar chart, make the marker size bigger than the bar chart above. Select a dark color.

how to 4.png

how to 5.png

3. For the bar chart above, make the maker size smaller than the background bar chart. Select a bright color.

how to 6.png

how to 7.png

4. Make the two bar charts have same size and location.

how to 8.png

how to 9.png

How to make an overlay of Area chart and line chart with SAP Dashboard so make the area chart look likes have a borderline in top:

You can download a file “Overlay of Area chart and line charts” xlf here https://drive.google.com/file/d/0B_485EXXLdAfNnZ4VlA1Ym1scjA/edit?usp=sharing

Actually there is no borderline for area chart by default. But we can do this with area chart and line chart together. The definite means are as follows:

Adjusting vertical label and horizontal label of the two types of chart:

  1. Make the two chart have same scale (could verify by showing vertical labels, this is very important) for the vertical labels, then hide all the vertical text containing vertical title and vertical labels.
  2. Align the horizontal labels of the two charts by adjusting the size and location of the two charts till the labels are strict alignment. You could adjust the color of the labels if you don’t want to show the horizontal labels.

You also can add another line chart with the same way like below screenshot.

how to 10.png

To report this post you need to login first.

11 Comments

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

  1. Runali Ghosh

    Hi Anita

    Nice tricks. Looks like they are created with Xcelsius. We xcelsius developers use similar tricks all the time. I am curious to know the relation to LAVA with Xcelsius.

    Thanks for the post

    Runali

    (0) 
    1. Anita Gibbings Post author

      Runali,

      I think this post I put up on Friday will give you some more insights: http://scn.sap.com/community/business-intelligence/blog/2013/10/25/the-what-and-why-of-project-lava

      In short Project LAVA is a design language or design vocabulary, it is not a new product or solution. So you can build using the design language of Project LAVA in the current solution using these work arounds. It is not yet certain if there will be any future development to make this easier in Dashboards.

      (0) 
    1. Anita Gibbings Post author

      Harshil,

      I think this post I put up on Friday will give you some more insights: http://scn.sap.com/community/business-intelligence/blog/2013/10/25/the-what-and-why-of-project-lava

      In short Project LAVA is a design language or design vocabulary, it is not a new product or solution. Basically you can choose to design using the principles of Project LAVA in the solution Dashboards and potentially in other BI solutions in the future.

      (0) 
  2. hari krishna

    Hi Anita,

                       The XLF files are not opening at my end. It shows me as they are corrupted, could you please recheck them.

    Thanks&Regards

    Krishna

    (0) 
    1. Anita Gibbings Post author

      Hi Hari,

      The problem is that SCN won’t it seems allow me to upload an .xlf type. So I’ve inserted into the blog a link to google drive and created a shared folder there where you will be able to download the files.

      Best Regards,

      Anita

      (0) 
      1. Colleen Cunningham

        Hi Anita,

        Great article.  I tried to download the file from the Google Drive, but the access was denied.  Therefore, I sent a request to you from my Google account so that you can grant me permission to download the *.xlf file…thanks.

        Sincerely,

        Colleen

        (0) 
        1. Anita Gibbings Post author

          Hi Colleen,

          I went through my google account and shared with all of you who have asked. I tried to reset the permissions too so people won’t have to request specifically but I’m not sure if that will work or not. At any rate, please let me know if you still can’t get them and I will email them to you directly.

          Best Regards,

          Anita

          (0) 

Leave a Reply