How to Install & Config Mondrian OLAP Server? (1)

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

SpagoBI uses SpagoBIXMLAEngine to access XMLA compliant server like Mondiran OLAP server.

This article records the detail of installing and configuring Mondrian OLAP server on the following environment. The solution below solved the reported issues that mondrian don't work well with JDK 1.6. You can find these issues at here or there.

Environment
============
SpagoBI: version 2.5
OS Server: Windows server 2008 R2 (x64)
App Server: Tomcat 6.0.26
Database: MySQL 5.1.48
Java: JDK 1.6 or JDK 1.5
Mondrian: 3.2.0.13661
Axis: 1.4

Prepare Works

• Download Tomcat server 6.0.26 from here, and unzip to local folder tomcat_home/;
• Download MySQL server 5 and jdbc driver (mysql-connector-java-5.1.12-bin.jar) from here, and setup by following MySQL documentation;
• Download Mondrian 3.2.0.13661 from here, and unzip to local folder mondrian-3.2.0.13661/;
• Download Apache Axis 1.4 from here, and unzip to local folder axis-1_4/.

Setup the Test Data in MySQL

Please follow the official Mondrian installation guide to install the test database "foodmart" into MySQL database.

Deploy Mondrian Web Application to Tomcat

• Explode the war file (mondrian-3.2.0.13661/lib/mondrian.war) to the folder at
  • tomcat_home/webapps/mondrian;

• Delete the following jar files:
  • saaj-api.jar
  • saaj-ri.jar
  • xalan.jar
  from the folder:
  • tomcat_home/webapps/mondrian/WEB-INF/lib

• Copy from the folder axis-1_4/lib these jar files:
  • axis.jar
  • commons-discovery-0.2.jar
  • saaj.jar
  • jaxrpc.jar
  • wsdl4j-1.5.1.jar
  to the folder:
  • tomcat_home/webapps/mondrian/WEB-INF/lib
  
  
• Also copy MySQL jdbc driver jar file to the folder ;
  • tomcat_home/webapps/mondrian/WEB-INF/lib

• Modify the file mondrian.properties from the folder
  • tomcat_home/webapps/mondrian/WEB-INF
• Modify the file datasources.xml from the folder
  • tomcat_home/webapps/mondrian/WEB-INF
• Modify the file web.xml from the above same folder;
• Modify the fourhier.jsp, mondrian.jsp, colors.jsp, testrole.jar, and arrows.jsp files as specified in mondrian installation guide from the folder:
  • tomcat_home/webapps/mondrian/WEB-INF/queries

Start MySQL Database

Start Tomcat server

Hit http://localhost:8080/mondrian.