1/2/15

SpagoBIMobileEngine: Bringing Business Intelligence to mobile devices

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.
          </p> <p style="margin-bottom: 10px; padding: 0px 0px 0px 30px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> This tag is used to show title on the chart, we can change the style tag to change the visibility of the title on page.</p> <p style="margin-bottom: 10px; padding: 0px 0px 0px 30px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> <columns></p> <p style="margin-bottom: 10px; padding: 0px 0px 0px 30px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> This is start of the table column tag. We can have more than one columns depending upon our requirements.</p> <p style="margin-bottom: 10px; padding: 0px 0px 0px 30px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> <column header=”Product Category” value=”ProdCategory” style=”font-weight: bold; text-align: center;” /></p> <p style="margin-bottom: 10px; padding: 0px 0px 0px 30px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> Column header is the header of column and value is the dataset field name.</p> <p style="margin-bottom: 10px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;">           Use the following tag in case you would like to link this chart to another document (cross navigation).</p> <p style="margin-bottom: 10px; padding: 0px 0px 0px 30px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> <drill document=”Mobile_Chart_LC1″></p> <p style="margin-bottom: 10px; padding: 0px 0px 0px 60px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> <PARAM  name=”ProdCategory” type=”SERIE”/></p> <p style="margin-bottom: 10px; padding: 0px 0px 0px 30px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> </DRILL></p> <p style="margin-bottom: 10px; padding: 0px 0px 0px 30px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> Here the document references the target document label and for each parameter, it is necessary to define the name (url) of the target parameter and the type of it.</p> <p style="margin-bottom: 10px; padding: 0px 0px 0px 30px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> The type can assume next values:</p> <p style="margin-bottom: 10px; padding: 0px 0px 0px 30px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> CATEGORY: pass the category’s value selected.</p> <p style="margin-bottom: 10px; padding: 0px 0px 0px 30px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> SERIE: pass the serie’s value selected.</p> <p style="margin-bottom: 10px; padding: 0px 0px 0px 30px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> ABSOLUTE: pass the constant defined into the value property.</p> <p style="margin-bottom: 10px; padding: 0px 0px 0px 30px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> RELATIVE: pass the value of the parameter presents in the request with the name defined in the same property.</p> <p style="margin-bottom: 10px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;">      3. Save and execute the document.</p> <p style="margin-bottom: 10px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> <strong style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline;">Develop Mobile Chart</strong></p> <p style="margin-bottom: 10px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> Please follow the steps below to develop mobile table:</p> <ol style="margin: 0px 0px 10px 3em; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline; list-style-position: initial; list-style-image: initial;"> <li style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline;">Create an analytical document with the following required information:<ol style="margin: 0px 0px 0px 1.5em; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline; list-style-position: initial; list-style-image: initial;"> <li style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline;">Label: the label of the document.</li> <li style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline;">Name: Name of the document.</li> <li style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline;">Type: Mobile Chart</li> <li style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline;">Engine: Mobile Chart Engine</li> <li style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline;">Data Source: your data source, e.g. foodmart.</li> <li style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline;">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.</li> </ol> </li> <li style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline;">Locate and upload the document template (.xml) file.</li> </ol> <p style="margin-bottom: 10px; padding: 0px 0px 0px 30px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> <strong style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline;">Details on the document template</strong></p> <p style="margin-bottom: 10px; padding: 0px 0px 0px 30px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> <strong style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> </strong><strong style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline;">Bar Chart</strong></p> <p style="margin-bottom: 10px; padding: 0px 0px 0px 30px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> <CHART_WIDGET  width=’320′ height=’480′></p> <p style="margin-bottom: 10px; padding: 0px 0px 0px 30px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> The width and height of the chart, we can have this value either in pixel or, percentage.</p> <p style="margin-bottom: 10px; padding: 0px 0px 0px 30px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> <title value=’Sales and Costs’>
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

</span></p> <p style="margin-bottom: 10px; padding: 0px 0px 0px 30px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> Configure the title of the document.</p> <p style="margin-bottom: 10px; padding: 0px 0px 0px 30px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> <documents></p> <p style="margin-bottom: 10px; padding: 0px 0px 0px 30px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> This is the start of the document tag. There is a block for every document that we would like to view/present in our cockpit/dashboard. We can add as many document tags as we need depending upon our views requirements. There is no limit and so we can create a composite document with 2,3,4,6, … sub-documents and everyone can shows different layout. The only limit is our common sense, because see too many documents can create confusion rather than help the data analysis.</p> <p style="margin-bottom: 10px; padding: 0px 0px 0px 30px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> <document label=”Mobile_Chart_Pie3″ width=”45%” height=”100%”></p> <p style="margin-bottom: 10px; padding: 0px 0px 0px 30px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> Label defines the label  by which the document is saved into SapgoBI.</p> <p style="margin-bottom: 10px; padding: 0px 0px 0px 30px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> </DOCUMENT></p> <p style="margin-bottom: 10px; padding: 0px 0px 0px 30px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> <document label=”Mobile_Table2″ width=”45%” height=”100%”></p> <p style="margin-bottom: 10px; padding: 0px 0px 0px 60px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> <in_parameters></p> <p style="margin-bottom: 10px; padding: 0px 0px 0px 90px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> <parameter urlName=”ProdCatType” defaultValue=”CATALOG_CATEGORY”/></p> <p style="margin-bottom: 10px; padding: 0px 0px 0px 90px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> <parameter urlName=”ProdCategory” defaultValue=”CPUps”/></p> <p style="margin-bottom: 10px; padding: 0px 0px 0px 60px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> </IN_PARAMETERS></p> <p style="margin-bottom: 10px; padding: 0px 0px 0px 30px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> </DOCUMENT></p> <p style="margin-bottom: 10px; padding: 0px 0px 0px 30px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> This is the configuration of the input parameters, urlName is the <em style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline;">label</em> by which the parameter is saved into SpagoBI (the url in detail document section) and defaultValue is a value that the engine pass to the document if is not found explicitly in the url.</p> <p style="margin-bottom: 10px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;">       3. Save and execute the document to show the composed view.</p> <p style="margin-bottom: 10px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> <strong style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline;">Others clarifications:</strong></p> <p style="margin-bottom: 10px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> In case the documents have cross navigation defined separately, the composed document will be shown as interactive, we do not need to define it in Cockpit. This should be defined in separate document with the following tags:</p> <p style="margin-bottom: 10px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> <drill document=”Mobile_Chart_LC1″></p> <p style="margin-bottom: 10px; padding: 0px 0px 0px 30px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> <PARAM  name=”ProdCategory” type=”SERIE”/></p> <p style="margin-bottom: 10px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> </DRILL></p> <p style="margin-bottom: 10px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> Here the document references the target document label and for each parameter, it is necessary to define the name (url) of the target parameter and the type of it.<br style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-size: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; outline: 0px !important; box-sizing: border-box;">The type can assume next values:</p> <p style="margin-bottom: 10px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> CATEGORY: pass the category’s value selected.</p> <p style="margin-bottom: 10px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> SERIE: pass the serie’s value selected.</p> <p style="margin-bottom: 10px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> ABSOLUTE: pass the constant defined into the value property.</p> <p style="margin-bottom: 10px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> RELATIVE: pass the value of the parameter presents in the request with the name defined in the same property.</p> <p style="margin-bottom: 10px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 18px; outline: 0px; box-sizing: border-box; vertical-align: baseline;"> <strong style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline;">Attachments  & References</strong></p> <ol style="margin: 0px 0px 10px 3em; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline; list-style-position: initial; list-style-image: initial;"> <li style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline;">SpagoBIMobile uses Sencha touch chart for rendering the charts, so please refer document on Sencha website i.e.<a href="http://www.sencha.com/products/touch/charts" style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline; text-decoration: none; color: rgb(244, 71, 58);">http://www.sencha.com/products/touch/charts</a> for details.</li> <li style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline;">SpagoBI Wiki, <a href="http://www.spagoworld.org/xwiki/bin/view/SpagoBI/MobileBI" style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline; text-decoration: none; color: rgb(244, 71, 58);">http://www.spagoworld.org/xwiki/bin/view/SpagoBI/MobileBI</a></li> <li style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline;">Enclosed please find sample document template for Mobile Table, Bar chart, Pie Chart, Line Chart and Cockpit at <a href="http://paxcel.net/blog/wp-content/uploads/2012/06/SpagoBI.rar" target="_blank" style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline; text-decoration: none; color: rgb(244, 71, 58);">http://paxcel.net/blog/wp-content/uploads/2012/06/SpagoBI.rar</a></li> </ol> </div> <footer class="entry-meta" style="margin: 25px 0px 0px; padding: 0px; border: 0px; font-family: Oxygen, sans-serif; font-size: 12px; font-weight: bold; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline; color: rgb(96, 96, 96); background-color: rgb(255, 255, 255);">This entry was posted in <a href="http://paxcel.net/blog/category/bi/" rel="category tag" style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline; text-decoration: none; color: rgb(244, 71, 58);">BI</a>, <a href="http://paxcel.net/blog/category/paxcellabs/" rel="category tag" style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline; text-decoration: none; color: rgb(244, 71, 58);">Paxcel Labs</a> and tagged <a href="http://paxcel.net/blog/tag/develop-bar-chart-in-spagobi/" rel="tag" style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline; text-decoration: none; color: rgb(244, 71, 58);">Develop bar chart in SpagoBI</a>, <a href="http://paxcel.net/blog/tag/develop-business-intelligence-report-in-spagobi-for-mobile-devices/" rel="tag" style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline; text-decoration: none; color: rgb(244, 71, 58);">develop business intelligence report in SpagoBI for mobile devices</a>, <a href="http://paxcel.net/blog/tag/develop-line-chart-in-spagobi/" rel="tag" style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline; text-decoration: none; color: rgb(244, 71, 58);">Develop Line Chart in SpagoBI</a>, <a href="http://paxcel.net/blog/tag/develop-mobile-charts-in-spagobi/" rel="tag" style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline; text-decoration: none; color: rgb(244, 71, 58);">Develop mobile charts in SpagoBI</a>, <a href="http://paxcel.net/blog/tag/develop-mobile-interactive-cockpits-in-spagobi/" rel="tag" style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline; text-decoration: none; color: rgb(244, 71, 58);">Develop mobile interactive cockpits in SpagoBI</a>,<a href="http://paxcel.net/blog/tag/develop-mobile-tables-in-spagobi/" rel="tag" style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline; text-decoration: none; color: rgb(244, 71, 58);">Develop mobile tables in SpagoBI</a>, <a href="http://paxcel.net/blog/tag/develop-pie-chart-in-spagobi/" rel="tag" style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline; text-decoration: none; color: rgb(244, 71, 58);">Develop Pie Chart in SpagoBI</a>, <a href="http://paxcel.net/blog/tag/spagobi-mobile/" rel="tag" style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline; text-decoration: none; color: rgb(244, 71, 58);">SpagoBI Mobile</a>, <a href="http://paxcel.net/blog/tag/spagobi-on-ipad/" rel="tag" style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline; text-decoration: none; color: rgb(244, 71, 58);">SpagoBI on IPAD</a>, <a href="http://paxcel.net/blog/tag/spagobi-on-iphone/" rel="tag" style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline; text-decoration: none; color: rgb(244, 71, 58);">SpagoBI on IPhone</a>, <a href="http://paxcel.net/blog/tag/spagobi-on-mobile-devices/" rel="tag" style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline; text-decoration: none; color: rgb(244, 71, 58);">SpagoBI on Mobile devices</a>, <a href="http://paxcel.net/blog/tag/spagobimobileengine/" rel="tag" style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline; text-decoration: none; color: rgb(244, 71, 58);">SpagoBIMobileEngine</a>. Bookmark the <a href="http://paxcel.net/blog/spagobimobileengine-bringing-business-intelligence-to-mobile-devices/" title="Permalink to SpagoBIMobileEngine: Bringing Business Intelligence to mobile devices" rel="bookmark" style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; outline: 0px; box-sizing: border-box; vertical-align: baseline; text-decoration: none; color: rgb(244, 71, 58);">permalink</a>.</footer></div>

Develop multidimensional analysis reports using Jpalo engine in SpagoBI

Develop multidimensional analysis reports using Jpalo engine in SpagoBI

Introduction
SpagoBI allows multidimensional analysis through OLAP engines, i.e. JPalo which are more flexible and user-friendly, compared to structured reports.
The users can monitor data on different detail levels and from different perspectives, through drill-down, drill-across, slice-and-dice, drill-through processes.
Configurations
The Jpalo engine comes configured with latest version of SpagoBI i.e. v3.4, but we would need to go through data source and related configurations. Please follow the step below to configure it properly:
  1. Mondrian Configuration
    a. In order to configure Mondrian to use a datasource as a JNDI resource, define resource in server.xml.b. Then configure it in SpagoBIJPaloEngine/META-INF/context.xml.c. Suppose your JNDI datasource resource is named “jdbc/foodmartmondrian”, then you need to configure DataSourceInfo tag in SpagoBIJPaloEngine/WEB-INF/datasources.xml
    to use the correct JNDI resource.
    Provider=mondrian;DataSource=java:comp/env/jdbc/foodmartmondrian;
    Use the following in case of jdbc (mysql) resource
    Provider=mondrian;Jdbc=jdbc:mysql://localhost/?user=root&password=;JdbcDrivers=com.mysql.jdbc.Driver;
    d. Remember that you can even put multiple catalogs and datasources under Mondrian control, by setting them in datasources.xml file.
    e. Further you have to place database schema FoodMart.xml (or the one you have prepared with all cubes defined), under SpagoBI resources folder.
    f. To be accessed by Mondrian server, change Definition tag in SpagoBIJPaloEngine/WEB-INF/datasources.xml.
    file:./../resources/Olap/foodmart.xml 
  2. Palo Pivot Configuration
    a. Change settings in SpagoBIJPaloEngine/WEB-INF/classes/deploy_it.properties. By default JPalo uses Hsql db to store its data, but it could eventually use Mysql. You can specify it by setting use.mysql=true otherwise you can set use.mysql=false. By default JPalo uses http protocol to connect to Mondrian. If you want to change protocol to https set is.ssl=true otherwise set is.ssl=false.More customization can be done:
    • jpalo.admin.user=[jpalo_username]
    • jpalo.admin.password=[jpalo_password]
    • jpalo.mondrian.connection.url=[mondrian_host]:[mondrian_port]
    • jpalo.mondrian.connection.service=SpagoBIJPaloEngine/xmla
    • jpalo.mondrian.connection.name=[name_of_mondrian_connection]
    b. Once you have decided what kind of database JPalo is going to use to store views and connections, you need to edit the proper settings.
    Case JPalo uses HSQL DB, change Hsql db settings in SpagoBIJPaloEngine/WEB-INF/classes/sql/hsql/credentials
    • jdbcDriver = org.hsqldb.jdbcDriver
    • jdbcURL = jdbc:hsqldb:file:[absolute_path_to_your_hsql_files]
    • jdbcPort = [port]
    • userName = [username]
    • userPassword = [password]
    Case JPalo uses Mysql DB, change Mysql db settings in SpagoBIJPaloEngineWEB-INFclassessqlmysqlcredentials
    • jdbcDriver =com.mysql.jdbc.Driver
    • userPassword = [password]
    • userName =[username]
    • databaseName =[schema_name]
    • jdbcURL =jdbc:mysql://[database_host]:[port]
  3. Please make sure the engine instance is created in SpagoBI server. Go to Resources->Engines Management and define/check SpagoBIJPaloEngine:
    • Document type : On-line analytical processing
    • Url : [protocol]://[host]:[port]/SpagoBIJPaloEngine/com.tensegrity.wpalo.SpagoBIJPaloEngine/JPaloEngineStartServlet
    • Driver : it.eng.spagobi.engines.drivers.jpalo.JPaloDriver
How to create Modrian Schema?This is a  .xml file where you define your olap cubes. The Jpalo engine read it and process it’s information to show the multidimensional reports.
There is an open source tool named “Schema-Workbench” where you can design your multidimensional cubes and save it as .xml file. As per above instruction, we store this file inside resource path of SpagoBI server.
Other links for schema-workbench and modrian:
You can work on other tools in the market also to develop mondrian schema.
Create Document in SpagoBI and run the report
a. Create new On-line analytical processing Document in spagoBI, using SpagoBIJPaloEngine. Go to “Analytical model->Documents development” and click on the Insert icon from the top left and fill the following information:
Type: on-line analytical processing
Engine: JPalo Engine
State: Development
e.g.
http://paxcel.net/blog/wp-content/uploads/2012/05/document.jpg
b. Save the document, and click on “Template build” button to create the view and execute the document just created.
c. In the next screen, click on the “Create new views” button from the left navigation area,
d. Choose the account, select the mondrian cube and click on Create button.
e. The view is created, now drag and drop the dimensions and save your view.
Once it is saved, it can be excuted directly from “Analytical Model->Documents development” page.
This is a detailed document which will help you to build Jpalo document with SpagoBI, please let me know in case you face any issue so that I can try to help you there. You can reach me through your comments.

12/24/14

My Five Rules for Remote Working

My Five Rules for Remote Working

A couple of weeks ago, there was a stir (again) about remote working and its succes and/or failure: it was reported that Reddit, the website where many people lose countless of hours, were forcing all their employees to move to SF. After a similar thing happened at Yahoo last year it made me think about why remote work is such a huge success for us at Activiti and Alfresco.
You see, I’m a remote worker for more than five years now. First at Red Hat and then at Alfresco. I worked a couple of years as Java consultant before that, so I’ve seen my share of office environments (checking my Linkedin, it comes down to about 10 different office environments). I had to go to these offices each day.
Comparing those experiences, I can – without exaggeration – say that I’m way more productive nowadays, working from home. Many people (both in and outside IT) ask me how I do it. They say “they couldn’t do it”. Maybe that’s true. Maybe some people need a lot of people around them. But for the kind of job I am into – developing software – I believe having a lot of people around me doesn’t aid me in writing higher quality software faster.
Anyway, like I said, I did some thinking around it and I came to the following “rules” which I have been following all these years which I believe are crucial (at least for me!) to making remote working a success.
dilbert_remote
(comic from http://www.dilbert.com/ )

Rule 1: The Door

Having a separate space to work is crucial when wanting do serious remote working. Mentally it is important that you can close “The Door” of your office space when you finished working. It brings some kind of closure to the working day.
Many people, when they work from home, put their laptop on let’s say the kitchen table. That doesn’t work. It is not a space that encourages work. There are distractions everywhere (kids that come home, food very close by, …). But most importantly, there is no distinction between when you are working and when you are not.
My wife and kids they know and understand that when The Door is closed, I’m at work. I can’t be disturbed until that Door opens. But when I close The Door in the evening and come downstairs, they also know that I’m fully available for them.
My door!
My door!

Rule 2: The Gear

The second rule is related to the first one: what to put in that room. The answer is simple: only the best. A huge desk, a big-ass 27″ monitor (or bigger), a comfortable chair (your ass spends a lot of time on it), the fastest internet you can buy, some quality speakers, a couple of cool posters and family pictures on the wall, ….
This is the room where you spend most of your time in the week, so you need to make it a place where you love to go to.
My setup
My setup
Often, I hear from people which company allows for remote work that their company should pay for all of this. I think that’s wrong. It’s a two-way street: your company gives you the choice, privilege and trust to work from home, so you from your side must take care that your home office isn’t decreasing anything compared to the office gear you have. Internet connection, chair and computer monitor are probably the most important bits here. If you try to be cheap on any of those, you’ll repay it in decreased productivity.

Rule 3: The Partner

Your partner is of utmost importance to make remote work a success. Don’t be fooled by the third place here, when your partner is not into it, all the other points are useless.
It’s pretty simple and comes down to one core agreement you need to make when working from home: when you are working from home you are not “at home”. When you work, there is no time for cleaning the house, doing the dishes, mowing the grass, etc … You are at work, and that needs to be seen as a full-time, serious thing. Your partner needs to understand that when you would do any of these things, it would be bad for your career.
Many people think this is easy, but I’ve seen many fail. A lot of people still see working from home as something that is not the same as “regular work”. They think you’ve got all the time in the world now. Wrong. Talk it through with your partner. If he/she doesn’t see it (or is jealous), don’t do it.

Rule 4: Communicate, communicate, communicate

More than a team in an office, you need to communicate. If you don’t communicate, you simply don’t exist.
At Activiti, we are skyping a lot during the day. We all know exactly what the other team members are currently doing. We have an informal agreement that we don’t announce a call typically. You just press the ‘call’ button and the other side has to pick it up and respond. It’s the only way remote work can work. Communicate often.
Also important: when you are away from your laptop, say it in a common chat window. There is nothing as damaging for remote workers as not picking up Skype/Phone for no reason.

Rule 5: Trust People

The last rule is crucial. Working remote is based on trust. Unlike in the office, there is no physical proof that you are actually working (although being physically in an office is not correlated with being productive!). You need to trust people that they do their job. But at the same time, don’t be afraid to check up on people’s work (for us, those are the commits) and ask the questions why something is taking longer than expected. Trust grows both ways.
The second part of this trust-story is that there needs to be trust from the company to the team. If that trust is missing, your team won’t be working remote for long. At Activiti, we are very lucky to have Paul Holmes Higgin as our manager. He is often in the office of Alfresco and makes sure that whatever we are doing is known to the company and vice versa. He attends many of the (online) meetings that happen company wide all the time so that we are free to code. There is nothing as bad for a remote team as working in isolation.
trust_fall

Conclusion

So those are my five (personal!) rules I follow when working from home. With all these bad press from the likes of Reddit and Yahoo, I thought it was time for some positive feedback. Remote work is perfect for me: it allows me to be very productive, while still being able to see my family a lot. Even though I put in a lot of hours every week, I’m still seeing my kids grow up every single day and I am there for them when they need me. And that is something priceless.