When the same fact table is used for more than one partition, it is important that data items not be used in more than one partition. It is possible for a data item used in more than one partition to be included multiple times when the cube is processed or queried, and to cause queries to return incorrect data.
You can use filters in partitions to ensure that no data is duplicated among the partitions. A partition’s filter specifies the data in the fact table that will be used in the partition. It is important that the filters for all partitions used in a cube extract mutually exclusive data sets from the fact table. For example, these sets of filters would be mutually exclusive within each set:
Set 1:
"SaleYear" = 1997
"SaleYear" = 1998
Set 2:
"Continent" = 'NorthAmerica'
"Continent" = 'Europe'
"Continent" = 'SouthAmerica'
Set 3:
"Country" = 'USA'
"Country" = 'Mexico'
("Country" <> 'USA' AND "Country" <> 'Mexico')
When you create mutually exclusive filters for partitions, ensure that the combined partition data includes all data you want to include in the cube.