Anouncing the release of Saiku 2.0 - Next Generation Open Source Analytics

Apr 26, 2011

For some quite time, the Pentaho community (specifically Tom Barber and Paul Stöllberger) is talking about a new web UI for data analysis (OLAP slice-n-dice) and after a few month of hard work they have released version 2.0 of Saiku and it is fully integrated with Pentaho.

 

 

 

 

Installation takes less than 10 minutes:

 

First download Saiku plugin and war file

$ wget ci.analytical-labs.com/jenkins/job/saiku-plugin/lastStableBuild/artifact/saiku-bi-platform-plugin/target/saiku-plugin-2.0-SNAPSHOT.zip
$ wget ci.analytical-labs.com/jenkins/job/saiku-webapp/lastStableBuild/artifact/saiku-webapp/target/saiku-webapp-foodmart-2.0-SNAPSHOT.war

 

Next we'll install the plugin and war file

$ unzip saiku-plugin-2.0-SNAPSHOT.zip
$ mv saiku biserver-ce/pentaho-solutions/system/
$ mv saiku-webapp-foodmart-2.0-SNAPSHOT.war biserver-ce/tomcat/webapps/saiku.war

 

 

Installation is done, you'll have to start the bi-server for the war to be deployed (extracted) and than you can add your datasource(s) by creating a new file under biserver-ce/tomcat/webapps/saiku/WEB-INF/classes/saiku-datasources/

I have configured Saiku to show the SQR cubes with this code:

type=OLAP
name=SQR
driver=mondrian.olap4j.MondrianOlap4jDriver
location=jdbc:mondrian:Jdbc=jdbc:mysql://localhost/software_qa_rpt;Catalog=../../pentaho-solutions/software-quality/issues.mondrian.xml;JdbcDrivers=com.mysql.jdbc.Driver;
username=root
password=secret

 

It seems to work flawlessly, please follow the link above for more screenshots, screencasts, docs, updates, issue tracking etc..