Thanks so much

Hi guys

OK, so I've set up saiku-server with multiple instances, each with its own port so that each user group can access a completely independent collection of cubes. But for some bizarre reason it's not keeping things completely separate:

1/12 : choose port 55000 for a new instance 2/12 : Make a dir under saiku-server named tomcat55000 3/12 : make copies of start and stop scripts and rename as start-saiku55000.sh and stop-saiku55000.sh 4/12 : edit each script and add export CATALINA_BASE="$DIR/tomcat55000" export CATALINA_HOME="$DIR/tomcat" 5/12 : copy CATALINA_HOME/webapps/ to CATALINA_BASE/webapps/ 6/12 : copy CATALINA_HOME/conf/server.xml to CATALINA_BASE/conf/ 7/12 : copy CATALINA_HOME/conf/web.xml to CATALINA_BASE/conf/ 8/12 : edit CATALINA_BASE/conf/server.xml and change shutdown port to 55001 and HTTP connector port to 55000 9/12 : make work, temp and logs dirs in CATALINA_BASE 10/12 : copy datasource and mondrian catalog to CATALINA_BASE/webapps/saiku/WEB-INF/classes/saiku-datasources 11/12 invoke start-saiku55000.sh

12/12 Now for the strange behaviour: When I access localhost:55000, everything works fine up to when I want to select a cube, as no cubes are on display. However, if I also copy the datasource and mondrian schema to the default 8080 instance and access localhost:8080 first, then the second attempt on localhost:55000 works right. I've tried to see whether any files in the CATALINA_HOME are amended, but none other than log files. Duplicating all datasources and catalogs in the default 8080 instance is clearly not feasable.

Why is this the case? Should I try and create instances in a different manner?

Regards