Re: Multiple fact tables

This depends of what system you are using. As Joerg points out you can
have have multiple fact tables on some OLAP systems such as MSAS 2000
by partitioning your OLAP system. In that case you need the MSAS
Enterprise edition.

In order to take advantage of the partitioned database just create a
new partition in your database editor (not inside the cube editor) the
new partiotion can be different from the existing ones by using MOLAP,
HOLAP and ROLAP storage mode - however standard MOLAP is the most
frequent used one.

Unfortenately using this techinque all fields in ALL partitions have
to be IDENTICAL, so if you are using two tables with a slightly
different table layout you need to rebulid them.

In many cases using the partition technique is very smart such as
having very large OLAP databases with data organized in partitions
representing years, or versions such as budgets versus actuals.

RE
Bjørn T