eMondrian

eMondrian is a free (R)OLAP server. It is a version of the Mondrian.

eMondrian supports XMLA standard. It allows connecting to eMondrian from Excel, Tableau, Power BI and client tools that use ADOMD.NET library.

Visit eMondrian project site for more information and documentation.

Building

See eMondrian Developer Guide.

Deployment

1. Download emondrian.war file.
2. Copy emondrian.war file to webapps directory of your java server (Apache Tomcat, Jetty, Tiny Java Web Server).

eMondrian contains:

• eMondrian Binaries
• Configuration files to deploy eMondrian to a servlet container (like Tomcat, Jetty, etc.)
• Sample databases
• The Schema Editor (Alfa Version)

How to connect to eMondrian:

• How to connect from Excel
• How to connect from Tableau Desktop

Connect ADOMD.Net application to Mondrian Cube

To connect to mondrian from ADOMD.Net application you must use folowing connection string:

Data Source=http://<your_server_address>:8080/emondrian/xmla;

For example:

Data Source=http://localhost:8080/emondrian/xmla;

REST metadata endpoints

eMondrian also exposes lightweight metadata endpoints based on the same datasources.xml and schema files used by XMLA:

• GET /emondrian/api/v1/metadata
• GET /emondrian/api/v1/metadata/version
• GET /emondrian/api/v1/metadata/catalogs
• GET /emondrian/api/v1/metadata/cubes?catalog=<CatalogName>
• GET /emondrian/api/v1/metadata/dimensions?catalog=<CatalogName>&cube=<CubeName>

These endpoints require no separate database connection settings.

OpenAPI / Swagger preview

• OpenAPI YAML: GET /emondrian/api/openapi.yaml
• Swagger UI preview: GET /emondrian/api/openapi-preview.html

Notes:

• catalog and cube query parameters are case-insensitive.
• For non-ASCII names in query parameters (for example, Cyrillic cube names), use URL encoding.