Mondrian OLAP server
| Developer(s) | Pentaho Corporation |
|---|---|
| Stable release | 3.2.0.13661
/ June 23, 2010 |
| Repository | |
| Operating system | Cross-platform (JVM) |
| Type | OLAP Server |
| License | EPL |
| Website | mondrian.pentaho.org |
Mondrian is an open source OLAP (online analytical processing) server, written in Java. It supports the MDX (multidimensional expressions) query language and the XML for Analysis and olap4j interface specifications. It reads from SQL and other data sources and aggregates data in a memory cache.
Mondrian is used for:
- High performance, interactive analysis of large or small volumes of information
- Dimensional exploration of data, for example analyzing sales by product line, by region, by time period
- Parsing of the MDX language into Structured Query Language (SQL) to retrieve answers to dimensional queries
- High-speed queries through the use of aggregate tables in the RDBMS
- Advanced calculations using the calculation expressions of the MDX language
Mondrian frontends
- JPivot
- Pentaho Analysis Tool
- Pentaho Analyzer