IBM Cognos Dynamic Cubes

124 IBM Cognos Dynamic Cubes

򐂰 Percentage of time spent retrieving data

This metric indicates the percentage of time data is retrieved from the back end database.

Higher percentage means worse performance and fewer cache hits.

򐂰 Result set cache hit rate

A higher hit rate means better result cache use and indicates that the majority of the report

results can be reused, improving query times.

򐂰 Up time

This metric indicates the length of time the cube is running.

5.3 Managing the cache

Dynamic Cubes support two types of caches that can be managed by the administrator:

򐂰 Member cache

This cache contains cube members that are loaded from the source relational data

source. The member cache can be refreshed when appropriate, such as when the source

data is changed, to update the cube with the latest metadata.

򐂰 Data cache

This cache contains data values that correspond to the current set of cache metadata.

This cache can be refreshed when the data values in the source relational data source are

changed. In general, data values change more frequently than cube metadata.

Use the following steps to manage the cache:

1. Refresh the member or data cache by clicking the down arrow next to the cube name

under QueryService and select Refresh member cache or Refresh data cache

(Figure 5-16).

Figure 5-16 Select Refresh member cache