Purging OBI Server and Presentation Server Cache:

Purging BI Server Cache:

• BI Server cache is stored in the directory: d:\Oracle\OracleBIData\cache • Create the script called PurgeBICache.sql with following command:

Call SAPurgeAllCache ();

• Run the following command to invoke the script and clear the cache: nqcmd -d AnalyticsWeb -u Administrator -p Administrator -s PurgeBICache.sql -o purge_clear.log

• This will clear all the BI server cache entries for all the users.

Purging BI Presentation Server Cache:

        Presentation cache stores the finished report output in the presentation server. This is different from BI server cache. BI server could be leveraged by multiple users and reports depending on whether they are accessing similar or subset of the cached data, though from a different reports.

 Presentation cache is report specific and user specific cache entries residing in the D:\OracleBIData\tmp\ folder.

The expiry of this entry can be governed by following instance-config.xml file in <>\web\config directory:

CacheMinExpireMinutes Default 10

CacheMaxExpireMinutes Default 15

 

View the original article here