SSAS Tip - IndexBuildThreashold

<IndexBuildThreshold> Index creation is controlled by the number of rows, specified in the msmdsrv.ini (default location of msmdsrv.ini file – ?:\Program Files\Microsoft SQL Server\MSAS10_50.SQL2008R2\OLAP\Config\msmdsrv.ini) file as <IndexBuildThreshold>, with a default of 4096. Partitions with fewer rows will not have indexes built. Which means if you have less than 4096 records in a Partition you will…

1