Different Fact Tables for Partitions
When you create a partition for a cube, you can choose to use the fact table specified for the default partition of the cube, or you can select a different fact table. All fact tables and dimensions for a cube's partitions must have the same structure as the fact table and dimensions of the cube. For example, different fact tables can have the same structure but contain data for different years or different product lines.
When you use different fact tables for the partitions of a cube, ensure that no data is duplicated among the fact tables. For example, if one fact table contains transactions for only 1997 and another fact table contains transactions for only 1998, they contain independent data. Similarly, fact tables for distinct product lines or distinct geographical areas are independent.
It is possible but not recommended to use different fact tables that contain duplicated data. In this case, you must use filters in the partitions to ensure that data used by one partition is not used by any other partition.
Note Merging partitions that have different fact tables requires special consideration and attention. For more information, see Fact Table Considerations When Merging Partitions.