Mondrian (Pentaho Analysis) is an open source OLAP server which is very popular and can be combined perfectly with JPivot and other XMLA OLAP client.

In this section you can find our data and solution samples for Mondrian.

Articles

1. Mondrian Setup with MySQL database
   
2. Mondrian as XMLA provider
3. JPivot and Ms Analysis Server 2000
4. Simple Cube with Sakila database
5. Check MySQL Foodmart Setup
6. Where should I put MySQL jar file ?
7. JPivot's mondrianQuery Tag
   

Tips

1. MDX Tips : Calculate Growth from Previous Period
   

Sample Files

1. MySQL Foodmart Database
2. JSP file to show Foodmart's Tables

New Wiki : Table of Contents

1. Mondrian Setup with MySQL database
   
1. MySQL: Check Foodmart Setup
2. Apache Tomcat: MySQL JDBC jar Setup
3. MySQL: Foodmart Database
4. Mondrian as XMLA provider
2. Configuring Mondrian Samples
   
• JPivot pivot table
• JPivot pivot table by XMLA
• JPivot with 4 hierarchies
• JPivot with role 'California Manager' set
• JPivot with arrows
• JPivot with colors
• Various queries formatted using the Mondrian tag-library
• Basic interface for ad hoc queries
• XML for Analysis tester
3. JPivot's Configuration
• JPivot: mondrianQuery tag
4. OLAP Design
   
• Simple Cube with Sakila database
5. MDX
• MDX : Calculate Sales Growth from Previous Period
• JPivot and Ms Analysis Server 2000

Screenshot of JPivot consumed Mondrian as an XMLA provider which shows 2 dimensional and 3 measures from Foodmart's Sales cube.