MAXFORMULACACHEMEMORYLIMIT

The MAXFORMULACACHEMEMORYLIMIT configuration setting enables you to control the overflow of the Essbase formula cache size (set by MAXFORMULACACHESIZE). Do not change this setting unless your queries need to consume more than 4GB for formula dependency evaluation.

MAXFORMULACACHEMEMORYLIMIT configuration applies to aggregate storage (ASO) databases and block storage (BSO) databases in hybrid mode.

Syntax

MAXFORMULACACHEMEMORYLIMIT [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 (cube), specifiy the cube name. If dbname is specified, appname must also be specified.
n—An integer that specifies the number of megabytes (MB) to set as the maximum cache size to be made available for calculating members with formulas. The default value is 4096 MB (4 GB) per query.

Any query that would overflow the limit will be stopped. If some dynamic formula evaluations require more memory, you can increase n to any required value.

Notes

This setting is only relevant if your query references at least one dynamic member with a formula, or if your MDX query has a calculated member in the WITH section.
The formula cache is allocated per calculation thread. Concurrent MDX requests can be allocated multiple cache objects, each with a maximum size specified in MAXFORMULACACHEMEMORYLIMIT.
The entire specified amount is not used unless needed.
The memory is released after the query completes.

Example

MAXFORMULACACHEMEMORYLIMIT 8192

Sets the formula cache size maximum to 8192 MB.