Specifies whether Analytic Services should wait for memory to be freed in the dynamic calculator cache, or use outside memory.
This setting does not apply to aggregate storage databases.
DYNCALCCACHEWAITFORBLK [appname [dbname]] TRUE | FALSE
appname | If you supply an application name, the setting applies to all databases within the application. If you do not supply an application name, the setting applies to all applications and databases on the server. |
dbname | If you supply a database name, the setting applies only to the database. If you do not also provide an application name, the setting applies to all applications and databases on the server. |
TRUE | Tells Analytic Services to wait for memory to be freed in the dynamic calculator cache. |
FALSE |
|
Use this setting to set or change how Analytic Services handles the situation when it needs additional memory to store blocks in the dynamic calculator cache for the database.
When the setting is TRUE, Analytic Services waits to store and calculate data blocks in the dynamic-calculator-cache area that is currently in use by other queries.
When the setting is FALSE, if the DYNCALCCACHEONLY setting is also FALSE, instead of waiting for area in the dynamic calculator cache, Analytic Services attempts to store and calculate data blocks for the current query in memory outside the dynamic calculator cache. If the DYNCALCCACHEONLY setting is TRUE, Analytic Services generates an error message instead of using memory outside the dynamic calculator cache.
The dynamic calculator cache is a memory buffer that holds data blocks that are expanded to include dynamically calculated members. Analytic Services allocates memory in the dynamic calculator cache to store these blocks during retrievals or calculations that involve dynamically calculated members.
Using the dynamic calculator cache may improve retrieval performance by reducing the number of calls to the operating system to do memory allocations. The size of the improvement depends on your database configuration.
Use the DYNCALCCACHEBLKTIMEOUT setting to specify the maximum number of seconds that Analytic Services waits for space in the dynamic calculator cache.
DYNCALCCACHEONLY FALSE DYNCALCCACHEWAITFORBLK FALSE
Analytic Services attempts to perform the block calculation in memory outside the dynamic calculator cache, instead of waiting for space to become available in the dynamic calculator cache.
DYNCALCCACHEMAXSIZE
DYNCALCCACHEONLY
DYNCALCCACHEBLKTIMEOUT
DYNCALCCACHEBLKRELEASE
DYNCALCCACHECOMPRBLKBUFSIZE
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |