MDX essentials - Course OLAP with open source tools - Part 11 | SQL courses

Duration: 13:29 min 

Summary: The MDX (Multidimensional Expression) is the language employed to query the data represented by a cube. This video show how to create a simple MDX query and how to modify it in order to obtain the data from a cube. The video explain the ON ROWS, ON COLUMNS, FROM, and WHERE clauses of a MDX’s SELECT statement in order to demonstrate how a expression is generated from the manipulation of the dynamic table controls and buttons. Also, the video point out where to find the documentation of MDX used by Mondrian and JPivot.

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

Examples constructed: The video shows how to write a simple MDX query to see a cube’s data

Keywords: OLAP, Cube, Mondrian, JPivot, Open Source, cube, MDX