Monday, April 12, 2010

Purging the cache in OBIEE!

I was going to write about how to delete a user in the catalog as my next post. The critical aspect, and the difference therefore, of that tip is the ability to do so without bringing down any of the services.


But then there was more than one person that was impressed with my first blog here. My friend, Hemanta, thought we should blog together, and so it happened.

So, what's the big deal about purging the cache? I am not able to recollect where I saw this, but the concept of using a logical column placed in the Fact logical table to take the value of a repository variable was a brilliant suggestion. So easily done, and so "logical". Question: what if I wanted to clear the cache ad-hoc, and without having access to the server or the admin tool?

Simple, given you know how to use a logical column to purge the cache. The cache of all tables related to a logical table is purged when the value of a variable attached to a logical column of that logical table changes:
1. Create a table with one field of type date. This table will have only one row
2. Use a direct database request to update the value in this table with the current timestamp
3. Create a repository variable to point to this value in the table, and set it to refresh every n minutes
4. Add a logical column to the logical table who's cache you need to clear, and assign this variable to this column

Should work :)

For those who have been here, and seen the one post that I had, and now this, please go to http://howtobi.wordpress.com/ and I will promise that I will not redirect you again!

No comments:

Post a Comment