Applies to aggregate storage databases, or to block storage databases when hybrid aggregation is enabled. Specifies the maximum size of the 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. The default is 1024.
If the amount of cache that Essbase sets aside for calculating members of 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.
Error 1200601 is likely to occur in situations where one dimension's dynamic calculations would expand beyond the current formula cache size setting.
If you see error 1200601, the following guidelines can help you determine what value to use for n:
Identify which queried dimensions are represented by dynamic members.
Multiply the sizes of those dimensions to get a number of members.
Multiply the number of members by 8 to get the recommended n value (not more than 4G).
For example, the default formula cache size of 1024 allows 1024/8=256 members to be in the cache.
The entire specified amount is not used unless needed.
Oracle recommends that you use this setting only in response to error 1200601.
Error 1200601 appears, stopping the current query, only in the case where one of the queried dimensions with dynamic members does not fit the formula cache size. Otherwise, the query runs even if the requested cache size is larger than the MAXFORMULACACHESIZE setting; however, the query is split internally into multiple calculators. The split query may run, but cause a decrease in performance Therefore, it is optimal for you to ensure that all dimensions in a query do fit within the formula cache size.
Sets the aggregate storage formula cache size maximum to 2048 KB for every application and database.