Aggregations - Course OLAP with open source tools - Part 12 | SQL courses

Duration: 17:54 min 

Summary: One of the main issues with OLAP technology, particularly when browsing a data cube, is the performance. To speed up the performance it is necessary to rely on some type of pre-calculated values, such as aggregations. This video shows how aggregations are handled in Mondrian and explain how to create a aggregate table, how to insert the correct that on it and how to specify in the schema that a cube must use this aggregation table to speed up cube browsing.

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

Examples constructed: The video shows how to work with aggregations in Mondrina

Keywords: OLAP, Cube, Mondrian, JPivot, Open Source, performance, speed,