Creating a Sparkline chart for IPad
Sparkline Chart on IPad
We have got a wide variety of charts available for us to work using BI 4.0
Here, I define the steps as to how to get Sparklines’ chart on an IPad. Sparkline chart is nothing but a tiny chart embedded within a cell.
Sparkline displays a trend based data in a clear and compact graphical representation.
The explanation is based on the following installable being used.
- SAP BusinessObjects Web Intelligence (Web Intelligence Rich Client) – BI4.0 SP3
- IPad App: SAP BI 4.0; Version: 4.0.3; Build: 1211
I have created a crosstab report using Web Intelligence rich client which gives Sales of few cities for first 6 months of a calendar year.
Steps to Perform on the Web Intelligence Rich Client Side
After creating the required crosstab, Right click on the table and click on Format Table.
The part SL_L_Revenues_C_2_7 represents the microchart. In this case, the meaning is
1) SL >>>Sparkline,
2) L >>> linear curve,
3) Revenues >>> Column Name which is to be shown as sparkline
4) C_2_7 >>>Column no 2 to Column no 7.
This means that we want the App to take columns 2 through 7 on our crosstab and format them as a non – filled chart (Linear curve).
Now on the IPad, open the SAP BO Mobile App and login to repository using appropriate credentials.
On login, the App displays reports which are available under Mobile category. Download the above report and open.
In case if we give the block name as “;SL_GF_Revenues_C_2_7 “ the axis will be shown as filled chart or shaded because gradient fill (‘GF’) is applied.
Nice on Harsha.
Info is helpful.
Great Webi trick !
You've been added to Webi 4.x tricks : summary for a better visibility. Keep posting !
Thanks for sharing.
Thanks for sharing.
I have new requirement that i have to show dual axis column line chart on mobile. Do u have any solution for that?
Can we applay these types of formulas for that??
i wanted sparkline on altenative columns like one on column 2,4,6 and another line for columns 1,3 ,5 .can we specify columns explicitly in the syntax so that this scenerio can be achieved..inputs on this at the earliest will be of great help
This trick has helped me well. now if apply a sum on months to display at the end of the column i get one value for each month forall cities. this sum values are not represented in sparkline format but are getting displayed as sole numbers nut on expanding by double click it shows as line . any way to represent the sum values too in spark line form