[OBIEE 11g] Clear Presentation Cache Auto Script

 

Clear Presentation Cache Auto Script

• OBIEE 11G has a catalog manager command called “ClearQueryCache” to clear out the PS cache.
• The syntax of ClearQueryCache command is:
  runcat.cmd/runcat.sh -cmd clearQueryCache  -online <OBIPS URL> -credentials <credentials properties file>
• Create a catalog manager credential properties file. Open a text file and type the following entries.
            Login = <weblogic_admin_Username>
            Pwd = <weblogic_Admin_Userpassword>  
  And save in a directory with the file name as catmancredentials.properties.
• Now open command prompt and navigate to <MW_HOME>instances\instance1\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\catalogmanager\
• And Run the following command to clear OBIPS query cache:
  runcat.cmd -cmd clearQueryCache -online http://host:9704/analytics/saw.dll -credentials E:\catmancredentials.properties