Pages

Friday, November 12, 2010

OBIEE - Purge BI Server Cache from Analytic Web Manually

All of us knows how to purge BI Server cache manually from Analytic Administration Tool i.e. Go to Manage > Cache. Select cache entries, right click and purge.



But what if you are working on reports remotely using Analytic Web and need to clear the BI Server cache? Here's the trick.

Go to Settings > Administration



In the Administration dialog select "Issue SQL"



In the SQL Statement textbox in the "Issue SQL Directly" dialog, enter the following statement and click "Issue SQL" button.

Call SAPurgeAllCache();




Allow some time for BI server to clear the cache. The page will refresh with results message at the bottom saying operation is successful.

You can also use other cache purge functions based on your need.

1 comment: