Mondrian OLAP server

{{external links|date=September 2017}}

{{Infobox Software

| name = Mondrian OLAP Server

| logo = Image:modrian logo.png

| screenshot =

| caption =

| developer = Pentaho Corporation

| latest_release_version = 3.14.0

| latest_release_date = {{release date|2017|05|17}}

| platform = Java

| genre = OLAP Server

| license = EPL

| website = {{URL|http://mondrian.pentaho.com/}}

}}

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 [https://web.archive.org/web/20150312031439/http://www.olap4j.org/ 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 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