Harsha G

May 2, 2013 2 minute read

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.

Make sure the blocks are aligned to left most possible so that viewing it on the IPad will be much more interactive.

So, if we see the block name, it is given in the format “;SL_L_Revenues_C_2_7″

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).

Save the report and export it to repository. Make sure that the report is saved under Mobile category.

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.

When the report is viewed on the device, the table displays a column titled “Revenues” that appears as Sparkline for the data values contained in columns 2 to 7 of the table. The Sparkline will appear as a linear curve because ‘L’ is used in the formula.

/wp-content/uploads/2013/05/3_211842.png

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.

/wp-content/uploads/2013/05/4_211843.png

If we want these kind of graphs to be seen on BO Mobile(IPad), the trick is to just to rename the block(table) on Web Intelligence rich client side and nothing to do on the IPad front. The app itself will convert the table for us into a microchart.

Thanks,

Harsha

6 Comments

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

Raghavendra Hullur

June 7, 2013 at 10:46 am

Nice on Harsha.

Info is helpful.

William MARCY

December 16, 2013 at 11:55 am

Great Webi trick !

You've been added to Webi 4.x tricks : summary for a better visibility. Keep posting !

William

Former Member

April 6, 2015 at 2:24 pm

Thanks for sharing.

Former Member

April 10, 2015 at 12:18 pm

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??

Plz reply

naveen raju

November 17, 2016 at 11:52 am

Hi,

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

Thanks
Naveen

naveen raju

December 27, 2016 at 10:14 am

Hi,

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

Thanks
naveen

Creating a Sparkline chart for IPad

Assigned Tags