Choosing a Calculator Cache Size for a Database

Table 177 shows which calculator cache option Essbase uses, depending on the calculator cache size specified:

Table 177. Selection of Calculator Cache Option Based on Calculator Cache Size

Minimum Size Specified

Option Selected

625,000 bytes

Option 1 (provides optimal performance)

125,000 bytes

Option 2

2,500 bytes[1]

Option 3

1 If you specify a calculator cache size of less than 2,500 bytes, Essbase does not use a calculator cache during the calculation. Calculation performance may be significantly impaired.

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.

Note:

The sizes of the calculator, index, data file, and data caches usually have a greater effect on performance if the database calculation is based more on aggregations and less on formula calculations.