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?