What follows is technical (geeky) and should be approached only by those personnel wearing appropriate safety equipment!
One command to remember
Call SAPurgeAllCache()
Login to dashboards as normal, and go to Administration and then Issue SQL
In the box that appears input the command from above.
Call SAPurgeAllCache()
Click Issue SQL
Server Cache cleared! I’ll leave you to clear the browser cache.
Here’s what the server cache looks like.
You can also clear the cache of specific databases.
Call SAPurgeCacheByDatabase( ‘MYDB’ );
Will clear just the MYDB database cache i.e. the OBIEE physical database in the right column.
There are other similar commands to clear specific tables / queries. That I’ll leave to you.
excellent piece of information, I had come to know about your website from my friend kishore, pune,i have read atleast 8 posts of yours by now, and let me tell you, your site gives the best and the most interesting information. This is just the kind of information that i had been looking for, i'm already your rss reader now and i would regularly watch out for the new posts, once again hats off to you! Thanx a lot once again, Regards, obiee online training
ReplyDeleteWell done. Concise, quick and effective
ReplyDeleteCall SAPurgeAllCache()
ReplyDeleteCall SAPurgeCacheByTable()
Call SAPurgeCacheByQuery()
seems this call is requiring weblogic password in my environment... unfortunately that useraccount does not have BI access. Is there a way of running the purge manually?
ReplyDelete