SQL Server Business Intelligence

SQL SERVER 2005 & 2008 IS THE MAIN THEME OF THIS BLOG

Monday, July 31, 2006

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

0 Comments:

Post a Comment

<< Home