Gotcha When You Process Update Dimensions
We can process cube related members via DDL statements.
Jamie posted a simple package which process all the dimensions and measure groups.
Jamie followed it with a
question in the forum and did a
post. I got interested in that and followed the thread and got it confirmed the following:
If your do process update on dimensions you are likely to lose aggregation on the cube.You have to re-build aggregations using "Process Index" option.I will post a simple package later on today which process all dimensions, specific partitions in a given measure group and finally it will build the aggregations for the cube.
Thanks
Sutha