Setting up the environment

Before we can do anything, it is important to have the right setup in place. In this recipe, I will describe the steps required to set up the environment for implementing analytics on top of ADempiere using Mondrian.

Getting ready

Verify that Apache Tomcat is installed and is running fine on your system. Note down the path where it is installed (we'll refer to this as TOMCAT_HOME) and also the port number, say 8080, on which it will be listening for client connections.

How to do it...

1. 1. Download Mondrian.

2. 2. Extract it to a folder of your choice, say, c:\mondrian. Going forward, we will refer to this path as MONDRIAN_INSTALL_DIR.

3. 3. Create a database in PostgreSQL with the following detail:

1. 4. Go to the MONDRIAN_INSTALL_DIR folder.

2. 5. Verify that the lib folder under it has the following JARs:

• If you don't find these JAR files in the lib folder, you shall be able to find them in the WEB-INF\lib folder after extracting the downloaded zipped file, the mondrian.war file...