OSBI/saiku — Issue #20: No Cubes being displayed in Saiku-ui
Author: buggtb
Created: 2011-10-11 14:48:11+00:00
State: open

This is an amazing tool, and I am tremendously excited to use it. I'm having some trouble getting everything hooked up, though. I'm running Mondrian, Saiku, and Saiku-ui on a Tomcat server on Ubuntu, with a Mysql database storing the data. I have set up a datasource/catalog for Mondrian, and can access basic MDX queries through its web interface. I have tried to set up Saiku to use the same data source (following instructions at http://projects.analytical-labs.com/knowledgebase/articles/3, adding a file to WEB-INF/classes/saiku-datasources), but am not sure if I have set it up correctly or not, because when I access the Saiku-ui, there are no Cubes available in the drop-down.

I get the following information from /saiku/rest/saiku/admin/datasources:

[{"name":"Users","properties":{"location":"jdbc:mondrian:Jdbc=jdbc:mysql://localhost/grockit?user=root&password=password;JdbcUser=root;JdbcPassword=password;JdbcDrivers=com.mysql.jdbc.Driver;Catalog=/WEB-INF/queries/Users.xml","password":"password","name":"Users","type":"OLAP","driver":"mondrian.olap4j.MondrianOlap4jDriver","username":"root"},"type":"OLAP"}]

Is there a good place to look for logs to help find debugging information, or even just to know whether or not the saiku server has successfully processed and accessed the data source?

Many thanks -- I'm very excited about using Saiku!