Original eMondrian documentation

Before this site, eMondrian’s instructions lived on the original eMondrian site. The pages below have not moved here yet. Some describe earlier setups — Tomcat on Windows, port 8080 — while the current installation is described in Install with Docker.

Connect clients

• XMLA service address — where the server answers XMLA requests
• How to connect from Excel
• How to connect from Tableau Desktop

Install

• Install eMondrian as a Docker container on Ubuntu — Docker Engine and the demo container
• Install eMondrian server on Windows — Java, Tomcat and the emondrian.war web application
• Open port 8080 in Windows 10

Develop

• eMondrian Developer Guide — build Mondrian and eMondrian from source with JDK, Maven and Git

Mondrian reference

eMondrian is based on Mondrian. The original site also keeps a copy of the Mondrian documentation; much of it still applies — especially the MDX language, configuration properties and the classic schema format.

• Mondrian documentation home
• What is OLAP
• Describe data sources in datasources.xml
• Writing a schema — cubes, dimensions, measures, roles, aggregate tables
• Configuration properties — mondrian.properties
• Optimizing performance
• MDX — the query language and its functions
• Mondrian 2.2.2 Technical Guide (PDF)

Classic format

The Mondrian documentation describes the classic schema format. eMondrian also supports an attribute-based format (DimensionAttribute, AttributeMapping, sourceAttribute) — see Schema reference.

Changing mondrian.properties

eMondrian ships with tuned defaults in its built-in mondrian.properties (for example session caching and aggregate tables are on). If you override the file, start from a full copy of the built-in one — a partial file replaces all defaults:

docker cp emondrian_service:/usr/local/tomcat/webapps/emondrian/WEB-INF/classes/mondrian.properties .

Then uncomment the mondrian.properties volume in docker-compose.yml and restart.