User Tools

Site Tools

2. Installation

This page describes how to install Spatialytics OLAP. Please check the pre-requisites section before starting the installation.

2.1 Pre-requisites

In order to run Spatialytics OLAP, three (3) things should be installed on you computer before starting the installation procedure.

  1. A Java Runtime Environment (JRE)
  2. A Servlet container like Apache Tomcat
  3. A PostgreSQL DBMS with spatial extensions (PostGIS) activated

If all these pre-requisites packages are already installed on your computer, you can directly go to the next section (Installation).


Spatialytics OLAP has been developed with the JRE provided by Sun (now Oracle). It should work with other JRE but it is has not been extensively tested.

Please go to the Oracle Java website and download the JRE 6 available for your system. Install it according to the installation instructions provided on the website. Especially, the JAVA_HOME environment variable should be defined and the java interpreter should be in your PATH.

Servlet container

Spatialytics OLAP has been developed with Apache Tomcat. It should work with other servlet container (like Jetty) but it is has not been extensively tested.

Please visit the Apache Tomcat website and download the latest version 6 of this open source servlet container. Install it on your system as explained in the Tomcat Setup page available in the Tomcat documentation.


In order to run spatial examples provided with Spatialytics OLAP, a PostgreSQL instance should be set up with PostGIS extension. Versions 8.3 and above of PostgreSQL now include PostGIS support. You are not compelled to install PostGIS in addition to PostgreSQL anymore but the PostGIS extension has to be activated during the installation step in order to be able to use it.

Please visit the PostgreSQL website and download the latest version 8 of this open source DBMS. Install it as detailed in the installation section of the PostgreSQL documentation.

2.2 Installation

Spatialytics OLAP comes to you as a WAR with JPivot and an embedded Apache Derby database that allows the running of the non-spatial samples available in the distribution. All necessary JARs for Spatialytics OLAP are contained in the WAR /WEB-INF/lib directory.

Note: The core of Spatialytics OLAP is a JAR that acts as “JDBC for Spatial OLAP”: providing connections and executing SQL against underlying relational databases. So, it could be used within your own Java application, deployed in a server or not.

The installation procedure is rather simple and comprises two (2) main steps.

1. Installation of the sample spatial datawarehouse

A PostgreSQL database dump (named is available for download on the Spatialytics OLAP download page. It contains schema and data for a simplified version of GeoFoodMart, a data warehouse with a spatial (geographic) dimension. It is based on Mondrian's FoodMart database, with additional tables with geometry columns for the Store dimension (i.e. geostore_store, geostore_city, geostore_state and geostore_country). All geometry data is derived from free data sources.

Please, download the archive available on SourceForge and unzip it in a directory of your choice. 2 files should be extracted:

  • simple_geofoodmart_readme.txt, a README file that contains the installation instructions
  • simple_geofoodmart.sql, which is the PostgreSQL/PostGIS dump of the simple_geofoodmart datawarehouse.

Create a new database named simple_geofoodmart from the PostGIS template. Please refer to the PostgreSQL/PostGIS documentation to know how to do it.

Finally, run the SQL script through psql:

psql -h localhost -U postgres -W -d simple_geofoodmart -f simple_geofoodmart.sql

After 2 or 3 minutes, the datawarehouse should be loaded into your PostgreSQL/PostGIS DBMS.

2. Deployment of the Spatialytics OLAP WAR

Download the geomondrian.war available on the Spatialytics OLAP download page and copy it in the webapps subdirectory of your Tomcat installation. Start up Tomcat.

That's it, Spatialytics OLAP is now installed. You can access the Spatialytics OLAP Getting Started page here and play with all the examples.

2.3 Installing the schema workbench

This page describes how to install a binary distribution of the GeoMondrian's schema workbench. This desktop application allows the easy creation and deployment of XML cube schema usable with GeoMondrian. This special distribution of the workbench is able to deal with the spatial component and hence the creation of spatial data cubes.

The workbench is a Java application, so it requires a Java Runtime Environment is installed on your computer. Please see the pre-requisites section above to know how to install the Oracle JRE.


The installation procedure is very simple. Download the archive on the SourceForge. Unzip it into a directory of your choice and you are done!

Workbench configuration

During the first start of the workbench, you have to configure a DBMS connection so that the workbench is able to retrieve data to feed the data cube.

On Windows, run or double-click the workbench.bat script available in the workbench subdirectory resulting from the extraction of the archive.

On Unix/Linux machines, execute

A window should appear. In the Tools menu, click on the Connection item. A dialog box as illustrated below should open.

Please fill in the different fields exactly as in the illustration.

Click Accept and you are now ready to use the workbench with the simple_geofoodmart spatial datawarehouse.

You can then open the simple_geofoodmart.xml data cube schema located in the TOMCAT_HOME/geomondrian/WEB-INF/queries directory and explore graphically the different dimensions, measures, hierarchies, levels and members that compose this sample spatial data cube.

en/spatialytics_olap/002_installation.txt · Last modified: 2015/04/20 08:29 by lvaillancourt

Page Tools