Hi All:

I have one dimension call “Product” and have only one level as "product
desc". I have set this dimension as a changing dimension. As the "Microsoft
SQL Server 2000 Analysis Services Performance Guide" indicate that if
aggregations that include the All level or the leaf level in a changing
dimension then it is Rigid aggregation. So I have set the aggregation for
the product; however once I do the incremential update on the product
dimension. The lazy process is active and use up all the cpu time to create
the aggregation for the product.

Any one know how can I leave out the lazy process to fire up?

Thanks,

kent

Hi Kent,

You can use DSOCommitMode to control that. Putting this value for example
on 2 and then lazy aggregations are done within processing time. However
that will take longer now ofcourse. Have a look at:

FIX: New Functionality for Incremental Update of Changing Dimensions
WGID:223
ID: 325289.KB.EN-US
http://support.microsoft.com/default...b;en-us;325289

HTH,
Bas

"This posting is provided "AS IS" with no warranties, and confers no
rights."