Chapter 8. Optimization and performance tuning 241
heap size and cache size considerations, see Understanding Hardware Requirements for
Cognos Dynamic Cubes at the business analytics proven practices website:
https://www.ibm.com/developerworks/analytics/practices.html
To use the aggregate cache, run the Aggregate Advisor to get and save recommendations for
in-memory aggregates, and enable the aggregate cache by specifying enough memory for
the corresponding cube setting, as described in 8.4.2, “Loading in-memory aggregates into
the aggregate cache” on page 221. At the core of the Aggregate Advisor logic is a
model-based evaluation that uses heuristics to analyze potential slices of the cube to
recommend aggregates that balances coverage with ...