Sakila is a movie rental sample database provided by MySQL. This
database is very suitable to demonstrate the use of Pentaho's tools in
In this article I will
show us how to get the sample database, creating a very basic cube
definition and query it - all without altering the underlying data.
- Get Sakila database sql script from http://dev.mysql.com/doc/#sampledb
For installation, follow instructions from http://dev.mysql.com/doc/sakila/en/sakila.html#sakila-installation.
- A running MySQL databaes server
- A running Mondrian web application
This is Sakila scheme - taken from MySQL's documentation. Click on it to see a larger view.
Mondrian Cube Definition (XML)
I will design my Sakila's cube as follows :
- 1 cube : Rental
- 1 hierarchical dimension : Customers with All Customers, Active, and Name levels
- 1 measure : Rental Counts
Based on the design, I specify all related elements into an XML definition
file. I named the file Sakila.xml
, put it under [MONDRIAN WEB APP ]/WEB-INF/queries
JSP query file
Now, we need to create a Java Server Pages (jps) file to query the cube. Named it rentalquery.jsp and put in under the same folder as Sakila.xml.
Replace text in red color with your own database setting.
You can download the XML definition and query file described above from the attachments at the end of the article.
If you encounter any difficulties during this setup, you can ask questions in our user group : http://groups.google.com/group/phi-mondrian-olap