Script to Purge Cache in OBIEE

This script would help you to clear the cache in OBIEE Environment.

Edit the Environmental variables as per your environment and run the script.

I have created a text file Purgecache.txt (E:\OBIEE_11G\Cache\Purgecache.txt), that would clear all the bi server cache.

call SAPurgeAllCache();
 

 @ECHO OFF
SETLOCAL
set ORACLE_HOME=E:\OBIEE_11G\Oracle_BI1
set ORACLE_INSTANCE=E:\OBIEE_11G\instances\instance1
set ORACLE_BI_APPLICATION=coreapplication
set JAVA_HOME=E:\OBIEE_11G\Oracle_BI1\jdk
set ESSBASEPATH=%ORACLE_HOME%\clients\epm\Essbase\EssbaseRTC


call %ORACLE_HOME%\bifoundation\server\bin\nqcmd -d  coreapplication_OH2097364878 -u weblogic -p Password -s E:\OBIEE_11G\Cache\Purgecache.txt

 Note: Save the script any where u like with extension .cmd in windows, .sh in windows