SSAS : Update a dimension won't drop aggregation process index won't rebuild aggregation
up vote0down votefavorite

I have a 'Employee' dimension which will be changed (modified) everyday, I made monthly partitions in cube and only process full the current month partition. Lately found that the past month's aggregation will not be dropped. Tired to 'ProcessUpdate' on this dimension and 'ProcessIndex' on partition but remained same. Also tried the setting 'ProcessAffectObjects'and 'ProcessIndex' again, still the same, tried both on lazyprocessing true and false with no luck. So my question is how to drop the stale aggregation on past month and rebuild them explicit ?

August 26th, 2015 3:26am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics