This content has been marked as final. Show 3 replies
I am doing the same. I chose SQL Results from drop down, in edit box prefix 'set variable DISABLE_CACHE_HIT=1' followed by what ever the query required. But this does not work in the presenation cache. The prompt still picks values from the presentation cache.
When I go to Administration -> Manage Sessions -> close all cursors
This removes the presenation cache.
But the users of the report will not have administration rights. So I am trying to put a button on the report which will preform the same function as 'close all cursors'.
Can someone help on this?
The OBIEE version is 10.1.3.4.1
Besides 'Close All Cursors', you can even try using the 'Refresh' button present on the dashboard (at the bottom left corner of the dashboard along with Print and Add to Briefbook options). This would reload the page with the cache cleared. Please try this and update if it works the way you want it to.