ASODEFAULTCACHESIZE

The Essbase configuration setting ASODEFAULTCACHESIZE designates the default size for the aggregate storage cache associated with aggregate storage (ASO) cubes. The aggregate storage cache grows dynamically until it reaches this limit.

Syntax

ASODEFAULTCACHESIZE [appname] n

appname—Optional. Specifies the application to which the ASODEFAULTCACHESIZE setting applies. If omitted, the setting applies to all new applications.
n—An integer value indicating default aggregate storage cache size in megabytes. If ASODEFAULTCACHESIZE is not set, the default size is 100.

Description

The aggregate storage cache facilitates memory usage during data loads, aggregations, and retrievals. When an ASO application is started, Essbase allocates a small area in memory as the aggregate storage cache for the application. As needed, Essbase increases the cache size incrementally, until the maximum cache size specified for the application is reached, or until the operating system denies additional allocations.

Example

ASODEFAULTCACHESIZE 200

Sets the aggregate storage cache size of all newly created or migrated ASO databases as 200 megabytes.