Cache Management

For this release of the OBIEE, if you run an initial or incremental load without first clearing the query cache, it is possible that reports that you run after the load process will reuse the cache that existed prior to the load process. This can result in inconsistencies between reports. There are several alternatives to mitigate this situation, such as:

• Configure the query cache to expire daily.

• Clear the cache tables manually as needed; for example, after you complete a load process.

• Schedule the system to clear the cache tables at same frequency as the incremental load process.

To clear cached queries:

1. Open the Oracle BI Administration Tool in online mode.

2. Use the Cache Manager page select (Manage, then select Cache) and select all cache entries.

3. Click select Action, then select Refresh.

To disable the cache:

1. Locate this configuration file: <root directory>\OracleBI\server\Config\NQSConfig.INI.

2. In the Query Result Cache Section, change the [ CACHE ] setting from ENABLE = YES; to ENABLE = NO;.

3. Save the NQSConfig.INI configuration file and restart the Oracle BI Server service.

See Oracle Business Intelligence Server Administration Guide, "Query Caching in the OracleBI Server" for more information on query caching in OBIEE.