Mondrian Version : mondrian-3.0.4.11371

This is a further sample which querying Sales Cube using JPivot interface. The cube data is derived from MySQL foodmart sample data which we can generate from Mondrian's zip bundle. The sales cube schema is defined in Foodmart.xml file.

The page shown will by default show 1 dimension (Product) and 3 measures (ROI, Store Cost and Store Sales). ROI iiself is a calculated measure based on Store Cost and Store Sales (ROI = (Store Sales -Store Cost) / (Store Cost) * 100).

This sample show an indicator with green and red colors depending on ROI measure with condition :

• If ROI is less than 150, the particular row shows a red color
  
• If ROI is greater than 150, the particular row shows a green color
• If ROI is exactly equal to 150, the particular row shows no color indicator
  

This time the sample demonstrate an image visualization feature to give us a better insight on our OLAP data.

• Mondrian web application with MySQL backend setup
• Check your MySQL foodmart database sample setup

File Configuration

Note : [TOMCAT_HOME] is the folder where your Apache Tomcat installed. For example : C:\apache-tomcat-6.0.16

Open your Mondrian web application and click on the sixth sample from the index page (JPivot with colors). You should see an OLAP data table with a JPivot toolbar. Drill through some of the dimension level nodes.

For example, my web application is located at http://localhost:8080/mondrian and my "JPivot with colors" sample url ishttp://localhost:8080/mondrian/testpage.jsp?query=colors. Screenshot below shows the page that have been drill through at some nodes.