Skip to Main Content

Obiee cache

SaiOct 2 2012 — edited Oct 2 2012
Hi gurus,

I am using Obiee Some times in Answers I am getting stale values, like if I apply prompt for a particular year I am getting the results for all the years.

Later I taught like it might be due to cache, So I cleared the Presentation Server cache after clearing it sometimes i got expected results. In that also even I clear the Presentation Server cache sometimes I didn't get expected results, So, I have to clear the Repository cache manually then I got results.

So, my question when I fire a query in presentation Services, Is it possible to know whether the fired query hit the database or cache (Presentation server cache or repository cache).

Please help me on this,