XML for Analysis tester


Mondrian Version : mondrian-

This sample shows the various XMLA queries executed against MondrianXmlaServlet servlet, and give the result as XML document.


Prerequisites Articles

File Configuration

The configuration detail that you need is in WEB-INF/datasources.xml which can see in this article.


Open your Mondrian web application and click on the ninth sample from the index page (XMLA for Analysis tester). 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 "XMLA for Analysis tester" sample url is http://localhost:8080/mondrian/xmlaTest.jsp.

  • You will see some actions list from a drop down combo. Select "1. discoverDataSources"

  • Click on "show request" button. The XMLA action will be shown in textarea below the button

  • Click on "run" button to execute the action query shown and you should get an XML document as the result

  • Done

You should try to execute another actions and see the results as your insights on Mondrian's XMLA behaviours.

Still Getting Errors ?

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 phi-mondrian-olap-subscribe@googlegroups.com to join the group. 

Note that you must get approval first before you can post.

Mondrian Training

For those of you  in Indonesia we have a regular training on OLAP and data warehousing subject using Pentaho Data Integration and Mondrian.

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 support@phi-integration.com.