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