An administrator is tuning the Caching services to improve Dynamic cube report performance.

To avoid using outdated data that might be stored in the cache, you can clear the cache. You might want to clear the cache manually if your data source metadata changes infrequently or if you want to clear the cache in between automatically scheduled cache clearing. When you clear the cache using the following steps, it clears everything in the cache.

Steps

1. Start IBM Cognos Connection.

2. In the upper-right corner, click Launch, IBM Cognos Administration.

3. On the Configuration tab, click Query Service Caching.

4. Select the server groups for cache clearing.

5. Click Clear cache.The status of the Clear cache command is displayed.If a cache is being used by one or more pending reports or queries, it is internally flagged as “stale” by this command and is automatically cleared as soon as this usage completes.

6. Click Close.

References: IBM Cognos Administration Version 10.1.0, Administration and Security Guide, page 253