You can change the following two settings in the Analysis Services configuration file (msmdsrv.ini) to 65536 (64K) to cause Analysis services to use fewer and larger pages to cache data.
OLAP\Query\DataStorePageSize
OLAP\Query\DataStoreHashPageSize
When you make this change, Analysis Services will use less memory during a ProcessIndex operation and it will release the memory quickly when the operation completes.
Note: This post is for my personal use










