Mondrian

Mondrian is an Online Analytical Processing (OLAP) server written in Java. It enables you to interactively analyze very large datasets stored in SQL databases without writing SQL.

It executes queries written in the MDX language, reading data from a relational database (RDBMS), and presents the results in a multidimensional format via a Java API.

Mondrian Architecture

Install

wget http://download.huihoo.com/mondrian/mondrian-2.4.2.9831-derby.zip
unzip mondrian-2.4.2.9831-derby.zip
explode lib/mondrian-embedded.war to TOMCAT_HOME/webapps/mondrian-embedded
Start up Tomcat
Hit http://localhost:8080/mondrian-embedded

olap4j

Mondrian 3.0 includes olap4j 0.9.6 along with significant improvements to security and additional function support.

PostgreSQL

C:\mondrian> java -cp "C:\mondrian\lib\mondrian.jar;C:\mondrian\lib\log4j-1.2.9.jar; C:\mondrian\lib\eigenbase-xom.jar;  
C:\mondrian\lib\eigenbase-resgen.jar; C:\mondrian\lib\eigenbase-properties.jar; C:\mondrian\lib\postgres-jdbc.jar"
    mondrian.test.loader.MondrianFoodMartLoader
    -verbose -tables -data -indexes
    -jdbcDrivers="org.postgresql.Driver,sun.jdbc.odbc.JdbcOdbcDriver"
    -inputJdbcURL="jdbc:odbc:MondrianFoodMart"
    -outputJdbcURL="jdbc:postgresql://localhost/foodmart"
    -outputJdbcUser=postgres
    -outputJdbcPassword=password

MySQL

$ mysqladmin create foodmart
mysql> grant all privileges on foodmart.* to foodmart@localhost identified by 'foodmart';
mysql> flush privilegs;
$ java -cp "/mondrian/lib/mondrian.jar:/mondrian/lib/log4j-1.2.9.jar:/mondrian/lib/eigenbase-xom.jar:/mondrian/lib/eigenbase-resgen.jar
:/mondrian/lib/eigenbase-properties.jar:/usr/local/mysql/mysql-connector-java-5.0.5-bin.jar"
        mondrian.test.loader.MondrianFoodMartLoader
        -verbose -tables -data -indexes
        -jdbcDrivers=com.mysql.jdbc.Driver
        -inputFile=/mondrian/demo/FoodMartCreateData.sql
        -outputJdbcURL="jdbc:mysql://localhost/foodmart?user=foodmart&password=foodmart"

或下载: http://download.huihoo.com/mondrian/create-foodmart-mysql.zip

Apache Derby

Pentaho

Mondrian Schema Workbench (Pentaho Analysis schema design)

Code

Pentaho packages detail: http://docs.huihoo.com/javadoc/mondrian/3.0.4/