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
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
0 Comments:
Post a Comment
<< Home