> We'd like to keep our fact table and agg table in different servers. > > Is this possible? It's not possible. Mondrian needs all tables to be accessible from the same JDBC connection, because it generates SQL statements to join the tables. Julian