Tuesday, April 17, 2012


Purging Cache via OBIEE analytics page


  1. Log into OBIEE using an Admin account (as weblogic)
  2. a) Go to Administration Page –
  1. Select “Issue SQL” under “Maintenance and Trouble Shooting”


  1. In Issue SQL screen,
  1. Unselect checkbox ‘Use Oracle BI Presentation Services Cache’
  2. In SQL statement box, Type:  call SAPurgeAllCache()
  3. Select Issue SQL button and see that operation was successful

No comments:

Post a Comment