Measures in Mondrian - Course OLAP with open source tools - Part 8 | SQL courses

Duration: 16:50 min  

Summary: A measure is the most important numerical value used for quantitative analysis in a cube. With measures the analysts can understand the data, make conclusions and manipulate the members of the dimensions to aggregate or un-aggregate the data. This video shows how the measures are created from the columns in the fact table and how they are defined by the <Measure> tag in the FoodMart.xml catalog. Also, the video shows the implementation details of measures that need to be created from calculations generated by specific expressions forwarded to the database as a part of a SELECT statement.

 

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

Examples constructed: The video shows how to manipulate measures in a Mondrian’s data cube

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