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..