eMondrian

Add business intelligence capabilities to your databases

More Quick start Project source

What is eMondrian

eMonrian is an open-source free OLAP server. It is based on the Mondrian project.
eMondrian allows you to interactively analyze data from multiple perspectives. You can consolidate, detail, explore your data from different points of view and quickly create your custom reports.
eMondrian creates an analytic space and hides the complexity of underlying tables and their relations. It represents data as cubes, dimensions and measures.

Why eMondrian?

Free

Save your budget. Get it for free.

Simple

eMondrian is created to be as simple as possible to deploy, develop and support.

Easy to change

It is an open source project. Customize it as you need. Use the power of the whole open source developer community.

Scalable

It could easily scale up and down to achieve the best result.

Effective

It is the most effective way to enhance your analytical environment. Pay only when you really need it - for customization and new features that you want.

Universal

eMondrian server can be hosted on any java server (Apache Tomcat, Jetty, Tiny Java Web Server). You can run it under Linux or Windows.

Connect to eMondrian from your favorite analytical tool

Excel

Power BI

Tableau

Qlik Sense

And more

How it works?

eMondrian hides complexity of underlying source from end-users and moves configuration responsibility from these users to a DBA or other app developer. It makes it simple to do Ad-hoc analysis and create enterprise reporting.

eMondrian server is a Relational OLAP (ROLAP) server that means it always shows real time data from a source. This server runs queries written in the MDX language, reads data from a source database and presents results in a multidimensional format.

Any database that has a JDBC driver can be the source for eMondrian.

eMondrian supports XMLA for Analysis and olap4j standards. You can fetch data from it through ADOMD.Net and OLE DB for OLAP libraries. So you can easily load data from eMondrian in your Java, .Net or Windows applications.

It has Role based access-control. You can manage access at cube, dimension, hierarchy and even at each row level.

It is easy to deloy, design data schema and support.

Documentation Quick start

Hi there! My name is Sergei Semenkov

I'm a freelance consultant and the developer of the eMondrian.

I have two decades experience in developing open source and Microsoft based OLAP solutions.

Consulting and Support

I can help you

Build and tune custom eMondrian configuration.
Deploy eMondrian server to your environment.
Bug Fixing and Changing eMondrian server behavior.
Design eMondrian schema. Create cubes, dimensions and measures for your database.
Set up Role based data access-control.
Tune eMondrian instance performance.
More

Quick start

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).

Connect Microsoft Excel to Mondrian Cube:

On Excel DATA tab select From Other Sources item and then select From Analysis Services.

Enter

http://<your_server_address>:8080/emondrian/xmla

as Server name.

For example,

http://localhost:8080/emondrian/xmla

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