Associating Sliders with Pie Charts
Applies to:
:
SAP BusinessObjects Dashboards and SAP BusinessObjects Business Intelligence 4.0 SP4. For more information, visit the SAP BusinessObjects Dashboards homepage.
:
Author: Mallikarjuna Chary Narayandas
:
Company: Gyansys Inc.
:
Created on: September, 21 2013
:
Author Bio
:
The author has worked on several SAP BusinessObjects projects and has experience on using all the SAPBusinessObjects Business Intelligence platform tools. Author has experience on working with SAPBusinessObjects mobile including designing and accessing BusinessObjects content (Web Intelligence Reports, Crystal Reports, Dashboards, Analysis and Information Spaces) through IPad / IPhone / Android.
:
Introduction
:
This article describes the techniques of building and associating sliders with pie charts on SAP BusinessObjects Dashboards. The content in this article is intended for all those developers in Dashboards space who are interested in playing around with components to achieve tricky requirements of dashboards and for end users who would wish to achieve powerful interactivity on their dashboards. This article covers the details steps of the logic used and steps implemented in achieving the requirement detailed below.
:
As most of us who use dashboards as developers already know that only some type of charts listed below do not have “Enable Range Slider” option in Behavior>Common properties using which dashboard consumers can focus on one small set of values in the initial view and then focus on others as and when required. For Example if we take requirements such as viewing monthly sales of current year in the initial view and be able to see historical years based on slider interactivity and requirements where users would want to see monthly revenue forecast for the immediate next year in the initial view and upcoming years based on slider interactivity etc. This blog is to address the limitation with a small work around.
:
- Pie Chart
- Bubble Chart
- XY Chart
- Radar Chart
- Filled Radar Chart
- Tree map
- Horizontal Bullet Chart
- Vertical Bullet Chart
:
What if we have similar requirements with viewing some data initially and rest on demand with slider interactivity on pie charts?
:
Well that could be a case more often than not with top level management preferring pie charts for various metrics and may look for something of this sort. Continue to read the below sections to get the answer.
:
Requirement Overview
:
When it comes to pie charts some of the CEO’s or top level management would always like to see few things like top 10/20 performing segments or business units and their sales revenue or top spending Business units/segments and their expenses or CEO of Marine Organization that contracts vessels might be interested in top 10/20 revenue generating vessels and would need flexibility of looking at the top 3-5 in the initial view and add more of them to the pie charts using slider interactivity.
:
Steps to Implement
:
Sample Dashboard referred in the steps below brings in data for top 7 vessels by Revenue to the dashboard and shows top 3 in the initial view and provides top 3-7 navigation based on slider interactivity. Attached is the sample dashboard file with .txt extension with static data and Excel logic used.
:
- Build Web Intelligence Report (if you are using an approach of Live Office or BI web services) and Rank the block of data using Rank options to consume only display data required for pie chart on dashboard. For Example In this we would be consuming only Top 7 vessels data even though webi report has availability of data beyond that.
:
- Publish the ranked data block as web service and consume it through Qaaws Connection or Use Live Office connection to consume block of webi data to Dashboard. Alternatively you can use any other connection type to consume data as long as you are able to handle ranking and bring only the data required for the dashboard consumption.
:
- Bind the block of data to the Source Data Area as in the screenshot below and Assign your slider data cell to the excel sheet (i.e. A2 in this case).
:
- Build formulae as below in the first column for all the for the data cells that refer to equal to and greater than the limit for the initial view data (top 3-7 Orange cells in screenshot) to use this as flag to control data to be shown on pie chart.
:
- =IF(A$2>2,1,0)
- =IF(A$2>3,1,0)
- =IF(A$2>4,1,0)
- =IF(A$2>5,1,0)
- =IF(A$2>6,1,0)
- =IF(A$2>7,1,0)
: 
- Use Formulae as below to retrieve plain data for the values less than the limit for the initial view data (top 2) and data values based on flag built in column A for cells that refer to equal or greater than the limit for the initial view data (top 3-7). Apply the same logic for the measure data and dimension data to be shown on chart.
:
- =IF(D5=””,””,D5)
- =IF(D6=””,””,D6)
- =IF(D7=””,””,IF(A7=1,D7,””))
- =IF(D8=””,””,IF(A8=1,D8,””))
- =IF(D9=””,””,IF(A9=1,D9,””))
- =IF(D10=””,””,IF(A10=1,D10,””))
- =IF(D11=””,””,IF(A11=1,D11,””))
:
- Bind the Dimension and measure data with formulae build above to the pie chart as Labels and values respectively. (Data cells in Green in the above screenshot).
:
- Ensure Ignore that Ignore Blank cells >In values is checked on Behavior>Common Properties so that pie chart shows only non-blank data in chart and legend.
:
- Ensure that slider settings are as below to get the resulted view of limits range.
::
- If the logic is implemented as per the above steps, pie chart output would vary based on slider as below at different slider levels.
:
Slider at Lower Limit:
Slider at Mid Limit:
Slider at Higher Limit:
:
Checks
:
- Test your logic in Excel first placing some static data in source data area and changing the number in destination cell of slider to see data is working as expected.
:
- Ensure setting of Ignore blank cells is checked on pie chart properties
:
References and Related Content
:
SAP BusinessObjects Dashboards
:
Space: SAP BusinessObjects Dashboards | SCN
:
For more information, visit SAP BusinessObjects Business Intelligence Platform
:
Disclaimer and Liability Notice
:
This document may discuss sample coding or other information that does not include SAP official interfaces and therefore is not supported by SAP. Changes made based on this information are not supported and can be overwritten during an upgrade.SAP will not be held liable for any damages caused by using or misusing the information, code or methods suggested in this document and anyone using these methods does so at his/her own risk.SAP offers no guarantees and assumes no responsibility or liability of any type with respect to the content of this technical article or code sample, including any liability resulting from incompatibility between the content within this document and the materials and services offered by SAP. You agree that you will not hold, or seek to hold, SAP responsible or liable with respect to the content of this document