Hi,
You can set the ASO cache by doing the following from the Essbase Administration Services console:
To view or change the size of the aggregate storage cache:
1 Right-click on the ASO Application in the EAS Console and select Edit properties.
2. In the Application Properties window, select the General tab.
3. Next to the Pending cache size limit node, enter a value, in megabytes, for the size of the cache.
4. Click Apply.
The cache setting takes effect after the application is restarted.
NOTE: The Aggregate storage cache facilitates memory usage during data loads, aggregations, and retrievals.
The default cache size is 32 MB. You can use the size of input-level data to determine when to increase the maximum size for the cache.
A 32 MB cache setting supports a database with approximately 2 GB of input-level data. If the input-level data size is greater than 2 GB by some factor, the aggregate storage cache can be increased by the square root of that factor. For example, if the input-level data size is 3 GB (which is 2 GB * 1.5), multiply the aggregate storage cache size of 32 MB by 1.22 (which is approximately the square root of 1.5), and set the aggregate cache size to the result: 39.04 MB.
Do not increase the maximum size of the aggregate storage cache beyond what is needed.
You can set the ASO cache by doing the following from the Essbase Administration Services console:
To view or change the size of the aggregate storage cache:
1 Right-click on the ASO Application in the EAS Console and select Edit properties.
2. In the Application Properties window, select the General tab.
3. Next to the Pending cache size limit node, enter a value, in megabytes, for the size of the cache.
4. Click Apply.
The cache setting takes effect after the application is restarted.
NOTE: The Aggregate storage cache facilitates memory usage during data loads, aggregations, and retrievals.
The default cache size is 32 MB. You can use the size of input-level data to determine when to increase the maximum size for the cache.
A 32 MB cache setting supports a database with approximately 2 GB of input-level data. If the input-level data size is greater than 2 GB by some factor, the aggregate storage cache can be increased by the square root of that factor. For example, if the input-level data size is 3 GB (which is 2 GB * 1.5), multiply the aggregate storage cache size of 32 MB by 1.22 (which is approximately the square root of 1.5), and set the aggregate cache size to the result: 39.04 MB.
Do not increase the maximum size of the aggregate storage cache beyond what is needed.
