Skip to Content

This Document will help you to visualize your dashboard KPI’S as slideshow. Sometimes user don’t want to interact with the dashboard however wants to view KPI’S as a slideshow so that the points can be discussed in Meeting. Downloading the data and then creating a PowerPoint presentation for the meeting is tedious as every time user need to download the data and convert it in to PPT format. With SAP Dashboards as we all know user can visualize the real time  , Interactive Data for their KPI’S  , this document will help you to add an add on to the Dashboard Features.

Tools Used:

SAP Dashboards 4.1

Components Required:

  • Charts: To display KPI Value.
  • Play Button: For Slideshow

Steps to use slide show feature in SAP Dashboards:

Step 1: Create a SAP Dashboard on Top of any Database (Here I Have Used excel to demonstrate my example) However any database can be used.

Step 2: Map the data in excel sheet to the components as below:

  1. Play Button :Note down the KPI’S name in an excel sheet and associate a number with each text as below:

    /wp-content/uploads/2014/12/1_613452.png

       Map the play button properties as below:

Source Data

Destination

Behaviour

Selector!$B$2:$B$4

Selector!$C$2

  • Auto Play
  • Play Time 20 sec(According to your need)
  • Selected Item: Item 1

   /wp-content/uploads/2014/12/2_613453.png

    Step 2. Take 3 charts for each KPI and map it data cells and set dynamic visibility as below


       

KPI

Component Used

Behavior Tab(Dynamic Visibility)

Status

Key

State Wise Sales

Column Chart

Selector!$C$2

1

Employee Count

Line Chart

Selector!$C$2

2

Top Customers

Column Chart

Selector!$C$2

3

How it Works:

On Preview Play button will take data from its source cells and send it to destination cell which is mapped to the dynamic visibility of the charts.

As In first 20 seconds of preview Data in destination cell of play button will be Selector!$C$2= 1  So chart: State wise sales will be visible as its dynamic visibility is set to 1.

        

/wp-content/uploads/2014/12/3_613499.png

/wp-content/uploads/2014/12/4_613500.png

After 20 Seconds data in Data in destination cell of play button will be Selector!$C$2= 2  So chart: Top Customers will be visible as its dynamic visibility is set to 2.

/wp-content/uploads/2014/12/5_613501.png

/wp-content/uploads/2014/12/6_613502.png

Similarly after another 20 Seconds data in Data in destination cell of play button will be Selector!$C$2= 3  So chart: Employee count  will be visible as its dynamic visibility is set to 3.

/wp-content/uploads/2014/12/7_613503.png

/wp-content/uploads/2014/12/8_613504.png

In case user want to pause the slide show in can click on the icon and can proceed manually.

/wp-content/uploads/2014/12/9_613505.png

Hope it helps.

Regards

Sheetal Sharma

To report this post you need to login first.

Be the first to leave a comment

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

Leave a Reply