JPivot with arrows

Introduction

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.

Configuration

Prerequisites Articles

File Configuration

Open and edit arrows.jsp file - which should be located in your
[TOMCAT_HOME]/webapps/mondrian/WEB-INF/queries folder - with your favorite text editor, and edit
<jp:mondrianQuery> with these following configurations :

Testing

Open your Mondrian web application and click on the fifth sample from
the index page (JPivot with arrows). 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 arrows" sample url is
http://localhost:8080/mondrian/testpage.jsp?query=arrows. Screenshot
below shows the page that have been drillthrough at some nodes.