Now what does this have to do with BI. Well, actually, I dont think it does...or do I!!
Each individual has a different way of looking at things around him. I was having a conversation with one of my colleagues about how we should highlight exceptions. The scenario is simple - source systems provide file feeds, and once the files are in, the transformations (ETL) kick in. And so I used my favorite BI tool to set up a complicated color scheme:
Files in time, ETL in time: Green
Files in time, but ETL not in time: Yellow
Files not in time, yet ETL in time: Light Green
Files not in time, ETL not in time: Red
The above was the user's perspective, but the colleague I was talking to was the one who had to meet the ETL SLA, and he quickly pointed out to the 2nd scenario, and said, that's what I need to know. That's what should be Red.
Now, was I talking about BI? What is BI anyway? How would you react if someone stole the stereo in your car? Would you have thought that maybe the guy who stole it needed it more than you did? And would you think the same way of all things around you?
My posts in this blogspot are going to move away from BI and I am going to start to talk a lot of nonsense. I am convinced that I will have one fan, and to the day that I am proved wrong, I will write!!! Sholong.
For people who are looking for serious tips on BI with the O in front and the EE that follows optionally, please visit http://howtobi.wordpress.com/. Btw, whatever be the path you chose to get to the end of my blog, I am glad you got this far ;)
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!
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!
Subscribe to:
Posts (Atom)