Pentaho Tools :

Pentaho C-Tools(CDE,CDF,CDA),Pentaho CE & EE Server,OLAP-Cubes,Analysis using Pivot4J, Saiku Analytics, Saiku Reporting, Ad-hoc Reporting using Interactive Reporting Tool,Dashboards,Reports using PRD, PDD,Data Integration using Kettle ETL,Data Mining usign WEKA,Integration of Servers with Databases,Mobile/iPad compatible Dashboards using Bootstrap Css,Drilldown dashboards,Interactive Dashboards

Thursday, 29 January 2015

Tip : Run 2 tomcats in Windows machine for jasper and pentaho ( Running Pentaho Server & jasper Server in one machine)

This post will let you know how to run 2 tomcats in single machine.

Jasper & Pentaho both are web application which run on tomcat server by default.

NOTE : This post will not give you the war file deployment of 2 softwares in any external tomcat 

I'm keeping jasper server's tomcat service.config file as it is(not modifying any thing) but modifying service.config file of pentaho's tomcat.

Do below changes in the pentaho service.config file.

Now, start both the servers .. you can find  both the servers running on single windows machine.

Changing shutdown port number, port, redirect port, encoding port.

1)


<Server port="8006" shutdown="SHUTDOWN">

2)
<Connector URIEncoding="UTF-8" port="9090" protocol="HTTP/1.1"
               connectionTimeout="20000"
               redirectPort="8444" />

3)

<Connector URIEncoding="UTF-8" port="8010" protocol="AJP/1.3" redirectPort="8444" />

 http://crunchify.com/how-to-run-multiple-tomcat-instances-on-one-server/

NOTE : Tested with Jasper Server 6.0 professional & pentaho 5.2 community server.

:-)

Friday, 23 January 2015

Tip : Adding trend Lines to Fusion Charts in Jasper Studio 6.x ( Adding average trend line in jasper studio to a bar chart)

This post will give you the starting point of working with trend lines in jasper studio .

Adding trend Lines to Fusion Charts in Jasper Studio 6.x  ( Adding average trend line in jasper studio to a bar chart)

Software Setup : Jasper Studio Pro 6.x, Jasper Server 6.x Pro, foodmart db.

Sample Data : 

OUTPUT image : 



Steps : 
1) Create a variable and calculate Avg as shown in below image.




2) Give this variable( it should be of integer type though your field may output BigDecimal values) for Start Value Expression & End Value Expression as shown image.

                           

NOTES : 
Can we find moving average trend lines in jasper ? NO.

References : 
1) How to add advanced properties :
http://community.jaspersoft.com/wiki/how-wrap-labels-pie-chart-pro

2) Customization properties
http://docs.fusioncharts.com/flex/charts/Contents/xml_elements_trend.html

3) http://en.wikipedia.org/wiki/Linear_regression