Can someone help me understand the impact of a child moving parents in
a dimension and how that affects reprocessing the cube?

I have a dimension that does not care about keeping history (i.e. I
don't need to see where the data how it looked a year ago, etc.). If
one of the children moves to a different parent, I have been
reprocessing the entire cube (which takes hours and puts a great deal
of load on the source database).

Is there any way to get around reprocessing the entire cube? This is
probably a pretty basic question, I feel like I'm missing some piece of
knowledge that would help me understand this better.

Thanks,
Todd

if you are using SSAS 2005 you can setup the relationship between 2
attributes to flexible instead of rigid.
in AS2000 you can activate the slow changing option of the dimension, but
insure that the levels use a unique key value.

in this case a member can move in a dimension and you don't need to
reprocess the cubes.
but the cubes are slower because AS can create aggregations for the levels
on top of this moving members.


"Todd" <toddkitta (AT) gmail (DOT) com> wrote