How to purge both Presentation Server and BI Server cache ?

OBI EE have two main Cache Mechanisms.
1.The Query Cache (BI Server cache) which is a data set cache.
Query caching is a persistent mechanism. It consists of Cache storage space, Cache metadata and Cache detection in query compilation.
2. The Presentation Server Cache which is an ODBC data set cache.
When user run analytics, Presentation server can cache the results.
There are several ways to purge the cache from both BI and Presentation services.


Process 1:
Go to the following path
Settings -- > Administrator --> Issue SQL
Call SAPurgeAllCache();
The above command will purge both Presentation server and BI server cache.

Process 2:

Purge BI server cache manually.

Go the following path

Admin Tool(Rpd) --> Manage --> Cache

The cache manger window will open with the saved cache entries.

Select All cache entries --> Rclick on it --> Select Purge

It will remove all cache entries saved in Rpd.

Process 3:

Using Cache Persistence time

Make the Physical table as Cacheable --> set the cache persistence time

For Ex: If we make PRODUCT  table as Cacheable and set Cache persistence time as 2 mins.

After the persistence time, cache entries will be removed automatically by the BI Server.

Process 4:

Presentation cache is report specific and user specific cache entries residing in the

OBI EE Installed Drive:\OracleBIData\cache\  folder.

Have names such as nQS_xxxx_x_xxxxxx.TMP
The expiry of this entry can be governed by following instanceconfig.xml file in C:\OracleBIData\web\config
CacheMinExpireMinutes Default 10
CacheMaxExpireMinutes Default 15