- Open the Msmdsrv.ini file. By default, this file is located in the following folder: C:\Program Files\Microsoft SQL Server\MSAS10.InstanceName\OLAP\Config
- Change the value of the IndexBuildThreshold tag from 4,096 to 0. This will enforce the creation of indexes for all partitions, even for the smallest one.
- Perform an index rebuild operation. For example, you can do this for the Adventure Works DW sample database by running the following XMLA script.
<DatabaseID>Adventure Works DW</DatabaseID>
<CubeID>Adventure Works DW</CubeID>
Article ID: 961699 - Last Review: Jan 19, 2009 - Revision: 1