Table 177 shows which calculator cache option Essbase uses, depending on the calculator cache size specified:
You can check which calculator cache option Essbase is able to use on a database by using the SET MSG SUMMARY command in a calculation script. Run the following calculation script on the empty database:
SET MSG SUMMARY; CALC ALL;
Essbase displays the calculator cache setting in the ESSCMD window or in the application log. See SET MSG SUMMARY and SET MSG DETAIL.
The maximum calculator cache size that you can specify is 200,000,000 bytes. The default is 200,000 bytes. The calculator cache size that you choose depends on available memory and the configuration of the database.