Duration: 16:37 min
Summary: A time dimension is a special type of dimension used by all the cubes in the sample FoorMart Datawarehouse provided by Mondrian. A time dimension defines how the time will be shown to the user when it is navigating through its data that can be organized in several different ways depending on how the hierarchies and levels are defined. Since Mondrian used only one shared time dimension based on a single table, the video show how this dimension table is related to the fact tables of the cubes, its data and how the FoodMart.xml catalog file defines the time dimension.
Technologies: Windows 7, Java, Mondrian, JPivot, MySQL, Apache Tomcat
Examples constructed: The video shows how to manipulate time dimensions in Mondrian
Keywords: OLAP, Mondrian, JPivot, Open Source, XML, tables