I have measure groups partitions by year. I have fact tables and dimension tables updated every day and only current year's fact data and related dimension members will be updated(insert/update/delete dimension members). For measure group partition, I will
only update the current year partition. However, if I use processUpdate to process the dimension, will the aggregates on previous years' partitions be invalidated? Actually, the dimension update does not change data in previous years' partitions. Will the
aggregates in these partitions be invalidated or not?
Thanks a lot.
View Complete Post