Understanding Dimensions - Course OLAP with open source tools - Part 6 | SQL courses

Duration: 17:03 min  

Summary: Dimensions are one of the most important concept in the OLAP world and Mondrian implements a dimension inside its XML catalog file. This video first explain how the dimensions are used to browse and filter data in the cube. Next, the video shows how the dimensions are obtained from the tables stored in the database. The relationship between dimension tables and the fact table of the multidimensional model is also shown followed by the explanation of how to create a manipulate the dimensions in the XML catalog file called FoodMart.xml.

 Technologies: Windows 7, Java, Mondrian, JPivot, MySQL, Apache Tomcat

Examples constructed: The video shows what are and how to manipulate the dimensions in the XML catalog of Mondrian

Keywords: OLAP, Mondrian, JPivot, Open Source, XML, cube