[Mondrian] Aggregate tables in another database

Nicholas Piper nick-mondrian at nickpiper.co.uk
Thu Jan 17 10:59:57 EST 2008

We're about to start using Mondrian, and have a question about keeping
the aggregate tables in a separate database to the fact table.

I've read
http://mondrian.pentaho.org/documentation/aggregate_tables.php and
http://mondrian.pentaho.org/documentation/configuration.php ,
but it seems there isn't an obvious way to tell Mondrian to use a
different database for aggregation tables?

We'd like to keep our fact table and agg table in different servers.

Is this possible?

Much thanks,


More information about the Mondrian mailing list