SaiOct 2 2012 — edited Oct 2 2012
I am using Obiee 22.214.171.124. 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,