By Pass Server Cache in OBIEE Answres

Hi,
   It's used to Overcome below kind of issue:
 .> Data Not Getting Refreshed in Answers when Changed in Base Database. Cache problem.


Let say User wants dashboard data updated on real-time after back-end ETL populates, then rather suggesting user to click on Refresh button each time is not the best option as fickle minded user1 could see stale data and can raise a hue and cry unnecessarily on old data .That could be easily avoided using Bypass Web Server Cache feature in Advanced tab of the corresponding reports .



Steps to implement By Pass Server Cache


1 Build Report with required fields,

2 Go to Advance SQL tab check the Check Box ' Bypass Oracle BI Presentation Services Cache'

3 Goto bottom of page look for 'Prefix' in text box type 'SET VARIABLE DISABLE_CACHE_HIT=1;'

4 Save the report

or

If you always want to bypass the Presentation server cache add this to the instanceconfig file of the development presentation server:

add below lines in instanceconfig.xml  file then restart all bi services.


<WebConfig>
<ServerInstance>
<ForceRefresh>TRUE</ForceRefresh>
</ServerInstance>
</WebConfig>




Thanks and Regards,


Deva