[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 ,
http://mondrian.pentaho.org/documentation/schema.php#Aggregate_tables
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,

 Nick



More information about the Mondrian mailing list