This video counties the OLAP with open source tools course. In this video we are going to see how to manipulate the data from an example cube that was created from the installation. The manipulation of the cube’s data is going to happen through the JPivot, the graphical interface of the Mondrian tool. This video shows how to slice a dimension, expand the member of a dimensional, add/remove/alter the dimensions by the OLAP Navigator, how to drill members, drill position, drill replace and drill through. Also, the video show options for ordering the measure values, how to configure graphs and export the report in pdf or excel (xls) format.
Technologies: Windows 7, Java, Mondrian, JPivot, MySQL, Apache Tomcat
Examples: The video shows how to manipulate the main options of the dynamic table provided by JPivot
Keywords: OLAP, Mondrian, JPivot, Open Source