Applies only to aggregate storage databases. Specifies the maximum size of the aggregate storage formula cache to be made available for calculating members with formulas.
MAXFORMULACACHESIZE [appname [dbname]] n
appname—Optional. To set the cache size maximum for a specific application, specifiy the application name.
dbname—Optional. To set the cache size maximum for a specific database, specifiy the database name. If dbname is specified, appname must also be specified.
n—An integer that specifies the number of kilobytes (KB) to set as the maximum cache size to be made available for calculating members with formulas.
If the amount of cache that Essbase sets aside for calculating members of aggregate storage outlines is insufficient, the following error is generated: "ERROR - 1200601 - Not enough memory for formula execution. Set MAXFORMULACACHESIZE configuration parameter to [n] and try again." The error recommends a value to use with the MAXFORMULACACHESIZE setting.
The entire specified amount is not used unless needed.
It is recommended that you use this setting only in response to error 1200601.
MAXFORMULACACHESIZE 2048
Sets the aggregate storage formula cache size maximum to 2048 KB for every application and database.