Skip to Content
Author's profile photo Harsha G

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.

/wp-content/uploads/2013/05/1_211815.png

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.

/wp-content/uploads/2013/05/2_211816.png

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

Assigned Tags

      6 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Raghavendra Hullur
      Raghavendra Hullur

      Nice on Harsha.

      Info is helpful.

      Author's profile photo William MARCY
      William MARCY

      Great Webi trick !

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

      William

      Author's profile photo Former Member
      Former Member

      Thanks for sharing.

      Author's profile photo Former Member
      Former Member

      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

      Author's profile photo naveen raju
      naveen raju

      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

      Author's profile photo naveen raju
      naveen raju

      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