Mondrian open source Java OLAP server 1.0
November 13th, 2003
I’ve been occassionally checking out Mondrian, which is an open source(!) OLAP server written in Java. In August, Mondrian hit 1.0 after two years of work. OLAP is a great thing, and Microsoft was the company with the most affordable OLAP solution.
Mondrian is a functional programming language. Tell them durn OLAPper latecomers to find a different name to rip off. See http://www.mondrian-script.org/
Can you provide a list of Java OLAP servers? I found Oracle OLAP API, OLAP4ALL, JOLAP (JSR 69 final draft) and now Mondrian. I want my to use OLAP’s facility in my JSP/Servlet/MySQL based system.
— Ashik
Mondrian is the only open source, java-based OLAP package I’m aware of.
Hi,
Can we connect to a OLAP Cube and extract information using mondrian olap apis.
As far as I know, there is no single standard for OLAP. So, the answer is generally “no”.
Mondrian allows you to create OLAP cubes in standard JDBC databases and query them.
By the way, the URL has changed to:
http://mondrian.sourceforge.net/
Hi,
1) Can anyone please suggest me how to access an MS OLAP Cube using Mondrian APIs.
Is it possible or not.
2) What is the difference between the Mondrian OLAP Cube and the MS OLAP Cube?
Please let me know.
As for #1, I doubt it (you might look around the Mondrian site to find out, or see if they have a mailing list you can subscribe to).
For #2, the biggest difference that I can see is that Mondrian does not rely on Microsoft’s database. Mondrian does appear to use CDX (the OLAP query language that Microsoft created), so they are similar in that regard.
You should have a look at PALO (www.palo.net) which is a MOLAP based OLAP Server, with an excel add-in.
It’s nice to see the open source olap market moving forward. They are going to have API’s in open source languages such as PHP and support open source operating systems such as Linux!
The roadmap is ambitious with planned features such as intercube rules (ie calculated real time elemenets) RTOLAP.
They are planning on offering a very reasonably priced support package, well reasonably priced if you consider the commerical vendors base support on a percentage of the list price of their software (which is often tens or hundreds of thousands)
There is a preview version available from http://www.palo.net along with the excel add-in and a sample C api application.
About Mondrian…it is now owned by the Pentaho open source project (www.pentaho.com). A great way to display Mondrian cubes is throught the OpenI Open Intelligence Portal (openi.org).
Hi’,
“Is it possible to use Excel in Mondrian?”, Actually I have a DB in Excel and I have to show it in Pentaho. I should be able to query the DB in Excel, Right now I am Using BIRT(eclipse) to make a report through Excel and then using BIRT as Input in Pentaho to show that again, Actually my real requirement is to query that Excel and show the final result .