Search code examples
mysqlmondriansaiku

How to create a Mondrian schema (xx.mondrian.xml) for MySQL data base

I am going to customise Saiku analysis tool for my local MySQL data base. For that I have to change the their existing data source as following manner, 

type=OLAP
name=steelwheels
driver=mondrian.olap4j.MondrianOlap4jDriver
location=jdbc:mondrian:Jdbc=jdbc:mysql://localhost/sampledata; \>Catalog=../webapps/saiku/steelwheels/steelwheels.mondrian.xml;JdbcDrivers=com.mysql.jdbc.Driver;
username=dbuser
password=password

According to above code, can any one please tell me how I generate Mondrian schema file called steelwheels.mondrian.xml with MySQL data base sampledata

Thanks

Solution

  • Download and open PSW or Pentaho Schema Workbench which can be found as part of the mondrian project on sourceforge.

    This is going away with Mondrian4, but thats ages away at the moment.