Batch file for clearing OracleBIServer cache OBIEE 11g on windows

1. Open a text file and paste the below code

call sapurgeallCache();

2. Save the file as purgecache.txt and place it into the location  %ORACLE_INSTANCE%\bifoundation\OracleBIApplication\coreapplication\setup\

3. Now open another text file and paste the below code

@echo off

set ORACLE_HOME=C:\oracle\middlewarehome\Oracle_BI1

set ORACLE_INSTANCE=C:\oracle\middlewarehome\instances\instance1

set ORACLE_BI_APPLICATION=coreapplication

set JAVA_HOME=C:\oracle\middlewarehome\instances\instance1

set ESSBASEPATH=%ORACLE_HOME%\clients\epm\Essbase\EssbaseRTC

call %ORACLE_INSTANCE%\bifoundation\OracleBIApplication\coreapplication\setup\bi-init.cmd

call %ORACLE_HOME%\bifoundation\server\bin\nqcmd -d coreapplication_OH829890363 -u weblogic -p welcome1 -s %ORACLE_INSTANCE%\bifoundation\OracleBIApplication\coreapplication\setup\purgecache.txt

pause

Here 

coreapplication_OH829890363 : DSN name 

4. Save the file as purgecache.bat

5. Double click the bat file and it will clear the cache