Hi,
Can anyone help me with this please
I have a confusion. I have a cube which has a fact table
and 3 dimensions Customer, Sales & Time.
Time dimension has 3 members
2002
2003
2004
I have made 2 partitions. One is my primary partition
which includes everything except year 2004. My second
partition is made using Time dim. slice with year
2004. Data is going to grow in 2004. While processing
the cube do I have to proces my both the partitions
everytime or only my second partition with 2004.
Also, data is growing in 2004. Therefore more keys will
be added in fact & dim tables. In this case do I have
process my dimensions & the whole cube with both
partitons or dimensions with the second partition or just
the second partition.

Thanks

Steve

Assuming that the dimension processing is incremental, you only need to
process the 2004 partition. If you do a dimension re-build you must
re-process all partitions.

public @ the domain below
www.tomchester.net

<anonymous (AT) discussions (DOT) microsoft.com> wrote