
Chapter 8. Optimization and performance tuning 225
Monitoring the aggregate cache load
Cube metrics available in Cognos Administration can be used to monitor and indicate when
aggregates have completed loading. Select the cube and view the following metrics:
Loaded/defined in-memory aggregates metric, which shows the number of completely
loaded aggregates to the number of defined in-memory aggregates
Time spent loading in-memory aggregates metric
Figure 8-19 shows an example of the gosldw_sales metrics, related to aggregate cache load.
Figure 8-19 Example of the gosldw_sales metrics related to aggregate cache load
Similar information is also av ...