Or, disable aggregation indexes completely by setting AggIndexBuildThreshold to a very large value such as 2,147,483,647. (AggIndexBuildThreshold is a signed 32-bit integer quantity.) Doing this eliminates the aggregation index building time from all processing but may also increase some query times. AggIndexBuildThreshold will not affect index building for partition data. It affects only indexes on aggregations.
Important When you install Cumulative Update 5 for SQL Server 2008 Analysis Services R2 Service Pack 1 or for SQL Server 2008 Analysis Services R2 Service Pack 2, the AggIndexBuildEnabled configuration setting is added to the Msmdsrv.ini file. By default, the value for the AggIndexBuildEnabled property is 0.
When the AggIndexBuildEnabled property is set to 0, aggregate index processing is disabled on partition index processing. Then, the problem that is described in this article no longer applies. To enable aggregate index processing, set the AggIndexBuildEnabled property to 1.
Article ID: 2537631 - Last Review: 20 Feb 2014 - Revision: 1