During our development if we wanted to check the report level UI changes, sometimes we will not see the changes immidiately. This is due to Presentation Server Cache. Eventhough we disable the BI Server cache, It doesnt make any effect on presentation Server objects.
So in that situations we need to disable Presentation server cache permanently across OBI Application, To do this add the following parameters in instaceconfig.xml. (Make sure that you have taken a backup copy of instanceconfig.xml)
<ServerInstance>
———
<Cursors>
<ForceRefresh>true</ForceRefresh>
</Cursors>
——–
</ServerInstance>
Now restart the OBI Presentation server service and test the results.
Note: Keep in mind that this parameters cause Presentation Server to always bypass its cache. To be used only for testing – may have serious performance implications.
Keep smiling 
Thanks,
Shiva
Riccardo
October 18, 2012 at 4:18 pm
Hi Shiva, in obi 11.1.1.6.4 I need for a prompt with default value set by an SQL query. Suppose that the query is a time string (YYYYMMDDHH24MISS’). I noticed that even if the runtime value of sql query change, the default is still the same.
For now I put in the SQL query WHERE ‘@{system.currentTime}’ = ‘@{system.currentTime}’
I tried also with your solution , but no succcess. Pls refer to https://forums.oracle.com/forums/thread.jspa?messageID=10644125
Narendra
June 12, 2013 at 9:48 am
Hi Shiva,
Thanks for the post.
I need to remove the Presentation server cache for one of the Database in my repository, not for entire application. Is there any way to delete/bypass cache for the DB instead for entire Presentation server cache.