How to Bypass cache in OBIEE

Follow below steps to disable the cache of the report to get results direct from the database;

 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 and add below statement in the prefix section
     SET VARIABLE DISABLE_CACHE_HIT=1;
 4. Save the report