SpagoBIMobileEngine: Bringing Business Intelligence to mobile devices

It is not surprising for Business owners to think of taking business decisions right from their gadgets with which they spend most of their time these days. Be it I-Pads, Tablets or the Smart phones, they are all part of our life now. What if those BI Reports you see in your browsers are made available on your I-Pad!…. I know you must be thinking there are many such applications, but what about an Open Source application which has provision for rich controls.

   

In this Blog, lets have a look at SpagoBIMobileEngine, one of the latest offerings of the new version of SpagoBI 3.4.

Now we can display our BI reports on mobile devices. This new component allows us to deploy the analysis available in SpagoBI suite onto mobile devices, such as smartphones and tablets, using original types of reports, graphs and interactive cockpits.

We have following three features added by SpagoBI for mobile so far:

1. Mobile Table: gives a tabular layout to data loaded from the associated dataset
2. Mobile Chart: displays Sencha-Touch charts over dataset data
3. Mobile Cockpit: composes charts and reports in a single layout, within the possibility for each document to interact with the others, passing them parameters

Here is our first experience in creating different kind of reports provided by SpagoBIMobileEngine.

Develop Mobile Table

Please follow the steps below to develop mobile table:

1. Create an analytical document with the following required information:
1. Label: the label of the document
2. Name: Name of the document.
3. Type: Mobile Report
4. Engine: Mobile Report Engine
5. Data Source: your data source, e.g. foodmart.
6. Dataset: locate the dataset for which you would like to develop table.Notes: Make sure the engine has been configured. This is configured by default with version 3.4.
2. Locate and upload the document template (.xml) file.

Details on the document template

This is the start of the table chart template.

         

Title of the bar chart document.

This is for legend where we set the position of the legend, one can comment this line in case they do not want to have legend on the page.

Display the value of the numeric control as we move the slider or needle.

This is animate configuration tag, which shows motion effect.

Other easing values, but I have no idea if SpagoBI supports all of these:

bounceIn, bounceOut, bounceInOut, elasticIn, elasticOut, elasticInOut, linear, quadIn, quadOut, quadInOut, cubicIn, cubicOut, cubicInOut, easeIn, easeOut, easeInOut, quartIn, quartOut, quartInOut, quintIn, quintOut, quintInOut, sineIn, sineOut, sineInOut, expoIn, expoOut, expoInOut, circIn, circOut and circInOut

SALES

COSTS

X

Configure series and axes to set/display fields on X and Y axis.

Interaction configuration, The PanZoom interaction allows the user to navigate the data for one or more chart axes by panning and/or zooming.

Pie Chart

Set the width and height of the pie chart.

The title of the document.

Legend configuration.

Configure interactions, type=rotate will rotate the chart with touch.

true

Set animation as true.

Configure series to set/display fields in pie chart.

End of the widget.

Line Chart

Set the width and height of the pie chart.

Set the title of the document.

Configure legend position.

Animate configuration same as above.

value1

value2

month

Configure series and axes to set/display fields on X and Y axis.

Interaction configuration, The PanZoom interaction allows the user to navigate the data for one or more chart axes by panning and/or zooming.

      3. Save and execute the document.

Develop Mobile Cockpit
Please follow the steps below to develop mobile table:

1. Create an analytical document with the following required information:
   1. Label: the label of the document.
   2. Name: Name of the document.
   3. Type: Mobile Cockpit
   4. Engine: Mobile Cockpit EngineNotes: Make sure the engine has been configured. This is configured by default with version 3.4.
2. Locate and upload the document template (.xml) file.

Details on the document template