Step by Step to Bypass All Caches
Today i have requirement for Live Report(by pass server cache, presentation cache) if this requirement is for one page among somany pages in same subject area, all other pages are cacheable then following solution will be ideal.
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