Using an Interactive InfoGraphic in your WEBI Report
Update – There is a sample WID file at O Meu Site – Home
with the name eua_sales_ – merged.wid (direct link – http://rogerplank1234.weebly.com/uploads/3/8/0/6/38067671/eua_sales_-_merged.wid )
It is in BO 4.1 SP5.
It´s downloadable and free of charge
I recently attend to an event of another BI Vendor. He demonstrate a way of utilizing an Infographic into its application. I thought “Humm perhaps it can be done in WEBI”, so I started to experiment and come to this solution.
I´m using an image of the map of the states of USA and plotted the anual sales revenue of the stores in the states, accordingly to e-fashion universe.
As you can see, when a hoover the mouse over california, it shows me the value of sales revenue for that state for all years (note the filter on [Year] on the filter bar).
The Infographic is dynamic in the sense of clicking on a state, the report will be filtered by that state.
The idea here is to use a buble chart on the top of the image and plot a dummy Excel file with the correspondmig coordinates of the desired states in the picture.
I used a picture, downloaded from the we,b with 800 x 501 pixels of size.
The hardest part was to get the points (x, y) of each state inside the picture. When doing it yourself bear in mind that, usually , the coordinates of the Y axis in the pictures is taken form the top to bottom, while for charts it´s taken from bottom up.
This was the Excel file used in this sample.
The resulting buble chart on the top of the picture is shown in bellow picture
To star to build your dynamic InfoGraphic, the first thing to do is to find the image and save it on the local machine. Once it´s done, drop a blank cell onto your report.
Right click this cell and choose Format Cell-> Appearance and check Image from Filee, like below :
Click on Upload. Set the hight and widht of the cell to accomodate the full picture.
Read your Excel file as personal data provider.
Create another query from the e-fashion Universe.That´s the query I use :
Execute both queries and merge them on State into Merged State.
Now, drop a bubble chart on the report, and assign it´s data like bellow
Align your buble chart from the bottom left corner of the cell.
Adjust the maximu value of the AXIS scale in the chart to the size of the Picture (AXIS 1 to 800 and AXIS 2 to 501).
Now, set the background transparency of the chart to 0
In Area Display unjcheck all visible information like below
See how the “bubles” in your chart are positioned on top of the image, correct the positioning in the x and y columns of your excel chart.
To finally hide the bubles themselves, go to Palette and Style , set the color to transparente and uncheck line symbol,
Now, when hoover the mouse over any state that contains data, you should be abble to see the name of the State and its X, Y and Valor.
To add the actual Sales Revenue of each state, I create a detail variable ,[Sales State] = FormatNumber([Sales Revenue] In [Merged State];”US$ ##0,000.00″), and assigned it as below
When you hoover the mouse, now you should be abble to see the value for the state as well.
Hope you liked it,
the file donot open.
which version of SAP BI you´re on ? The sample was done in SAP BI 4.1 SP5.
This is cool, I was looking for something like this, back in 2010.
One word : crazy ! 😆 😆
So, this example makes me think about 2 points :
- First, BI 4.2 SP3 with Geomap is so sweet 😉
- And use SAP LUMIRA ! 😎
But the really good point is that you can enter in Webi 4.x tricks : summary !
Thanks for your comment.
Sure, you´re right, it´s not ment to be used with maps.
I took the idea from a Tableau presentation. The guy used this approach with a funnel chart.
The idea for using a map was just to show the capabilities of it.
You can create a clickable area in a picture , so you can define new kinds of chart to be clicked on.
Yep, great trick to show Webi capabilities !