If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Dynamic cubes cache

Started by Hurge, 15 Sep 2014 08:56:22 AM

Previous topic - Next topic

Hurge

Hi all.
I installed Dynamic cubes & samples, then I published gosldw_sales package of DC.
I worked in the studio and made sure cognos sends sql requests to the DWH.
Now I want to make In-memory aggregates. I want to see that the database does not executes sql requests.
I set "Data cache size limit (MB)", "Maximum amount of disk space to use for result set cache (MB)", "Maximum amount of memory to use for aggregate cache (MB)" to 102400000 for cube.
I set "Initial JVM heap size for the query service (MB) (Requires QueryService restart)", "JVM heap size limit for the query service (MB) (Requires QueryService restart)" to 6144 for Query service (total phisical memory 8Gb).
Then I restarted Query service and refreshed cube. There is no effect.
What is the problem?