We have a MySQL server that has multiple databases, unfortunately some of the data between those databases is related and would be of use to build analysis on.
I've tried calling the tables using 'database.table' in the schema/cube, however that doesn't seem to work (I get "SocketException: Connection timed out" when trying to load the schema in Saiku). When defining the data sources, I can't leave the database name blank to make it default to a top level view.
The MySQL user/password has select permissions on all databases in question.
Any advice on how to make this work, or can I use multiple data sources within a single schema/cube? Thanks for any suggestions.