Tuesday, May 5, 2015

Clearing the cache using the Issue SQL page

Log into OBIEE Analytics using an ID that has the “Administration” link privilege.
http://server:9704/analytics
Click on the “Administration” link located at the top right of the page.
Administration_link
Click on the “Issue SQL” link at the bottom left of the page.
Issue_SQL_link
In the Issue SQL window, enter the command:  “call SAPurgeAllCache()” (without the quotes)
Click the “Issue SQL” button to execute the command.
Issue_SQL_Window_and_command
You should see a message indicating that the command was executed successfully (assuming you have caching turned on).
Your cache directory located at …
[FMW_HOME]/instances/instance1/bifoundation/OracleBIServerComponent/ coreapplication_obis1/cache
… should now be empty.

No comments:

Post a Comment