Step 1 : Create a .txt file as purgecache.txt and placed into loc : /ebsapp/BIDEV/apps/admin/instances/instance1/bifoundation/OracleBIApplication/coreapplication/setup In the file, enter the code call SAPurgeAllCache() , this is special BI command for clearing the cache. Step 2 : Create a shell script as purgecache.sh In .sh file, entered two commands /ebsapp/BIDEV/apps/admin/instances/instance1/bifoundation/OracleBIApplication/coreapplication/setup/bi-init.sh /ebsapp/BIDEV/apps/product/Oracle_BI1/bifoundation/server/bin/nqcmd -d AnalyticsWeb -u username -p pswd –s /ebsapp/BIDEV/apps/admin/instances/instance1/bifoundation/OracleBIApplication/coreapplication/setup/purgecache.txt Step 3: Open the putty software and run the purgecache.sh script