Mini-Summary: The Mondrian/JPivot solution relies on a database to store the data that the OLAP cube shows. In this video we used the MySQL database server to host the demo database called FoodMart, which is a regular relational database composed of many tables with relationships. This video explain the main table contained in the FoodMart database, its relationships, and shows the diagrams with the multidimensional modeling of following data cubes: expenses, inventory 1997, inventory 1998, sales 1997 and sales 1998.
Technologies: Windows 7, Java, Mondrian, JPivot, MySQL, Apache Tomcat
Examples: The video shows the organization and the modeling of the foodmart database
Keywords: OLAP, Mondrian, JPivot, Open Source, Foodmart