IntroductionSakila is a movie rental sample database provided by MySQL. This database is very suitable to demonstrate the use of Pentaho's tools in various way. For this purpose, I'll write a series of articles showing the use of Sakila with Mondrian and Kettle. And to begin with, this first article will show us how to get the sample database, creating a very basic cube definition and query it - all without altering the underlying data. Download and Installation
Sakila SchemeThis is Sakila scheme taken from MySQL's documentation. Click on the image to see the larger complete view. Create Mondrian Cube's XML fileFor this sample, I will design my Sakila's cube as follows :
From this definition, I specify all related elements into XML definition file. Here I name the file Sakila.xml and put it into [MONDRIAN]/WEB-INF/queries folder. Create a JSP's query fileNow, create a rentalquery.jsp file in the same folder as Sakila.xml.Replace text in red color with your own database setting. Testing the result
Downloadable resourcesYou can download the XML definition and query file from the attachments at the end of this article.Related Articles |
Mondrian >