Have any one noticed this behavior??
Incremental process (process update) of dimension generates reprocessing of indexes on all cube's partitions,even when no change has occured in that dimension.
I am using SSAS 2005 sp2.
This is disturbing because my cube holds some 700 daily partitions so processing indexes on all of them - on an hourly basis - is very time consuming.
Also it flashes that cube's cache!
I did noticed that changing heirarchies memberskeysunique property to True + changing the toppest attribute in this heirarchy mambernamesunique to true solves this problem.
Is this a must then to prevent recalculating indexes on partitions every process update of dimension??
View Complete Post