Introduction

Mondrian (Pentaho Analysis) is a popular open source OLAP engine / server. 

Articles

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