No Cubes being displayed in Saiku-ui about saiku

[buggtb]

this looks ok to me
you can check the tomcat/logs/catalina.out file. if there was an error then you should see it there

if there is an error, you could paste it to me in here and i can tell you whats going on

-paul

[buggtb]

Wonderful! Thank you, Paul! I did see an error when Tomcat was deploying the Saiku server (copied below for future reference by others). It looks like there is a path issue with the Catalog file, My "solution" was to pass in the full path to the file, so that my datasources file (classes/saiku-datasources/Users) replaces 'CATALOG=/WEB-INF/queries/Users.xml' with 'CATALOG=/usr/local/tomcat/webapps/saiku/WEB-INF/queries/Users.xml' This seems a little bit inelegant, but it works. Thanks again, Paul!

The original error in the catalina.out file was:

INFO: Deploying web application archive saiku.war

-- listing properties --
location=jdbc:mondrian:Jdbc=jdbc:mysql://local...
name=Users
password=gaff7rust
type=OLAP
driver=mondrian.olap4j.MondrianOlap4jDriver
username=root
mondrian.olap.MondrianException: Mondrian Error:Internal error: Virtual file is not readable: /WEB-INF/queries/Users.xml

[buggtb]

yeah this is something i want to address at some point (firstly datasources via admin interface + better way to store files etc)

You can use a path like:
Catalog=../webapps/saiku/WEB-INF/queries/User.xml (this should work fine in a tomcat etc but its a bit nasty)

The solution we use at the moment is (from 2.1 on):
Catalog=res:foodmart/FoodMart.xml

this will look for a classpath resource (res:)
By default WEB-INF/classes/ is on the classpath so if you put Users.xml in WEB-INF/classes/queries/Users.xml you can use:
Catalog=res:queries/Users.xml

hope that helps

-paul

[pstoellberger]

considering it done