Mondrian Version : mondrian-126.96.36.19971
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 4 dimensions - with "All Members" as default level - from Sales cube in one axis, they are :
Open and edit fourhier.jsp file - which should be located in your [TOMCAT_HOME]/webapps/mondrian/WEB-INF/queries folder - with your favourite text editor, and edit <jp:mondrianQuery> with these following configurations :
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 third sample from the index page (JPivot with 4 hierarchies). 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 4 hierarchies" sample url is http://localhost:8080/mondrian/testpage.jsp?query=fourhier. Screenshot below shows the page that have been drillthrough at some nodes.
If you already following all the instructions and still got some errors or you have other issues that has to do with other database sources then you can post your problem to our Mondrian user group at http://groups.google.com/group/phi-mondrian-olap. Or you can send a blank email to email@example.com to join the group.
Note that you must get approval first before you can post.
If you want to enroll for the session please feel the form at http://pentaho.phi-integration.com/pendaftaran-training and we will send you the training schedule.
And for those who like to have a remote training instead using Webex please contact us by email to firstname.lastname@example.org.