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

If you have any prompts on this page, want live data to be pull in prompts, for that while creation of prompt go to show, choose SQL Results from drop down, in edit box prefix 'set variable DISABLE_CACHE_HIT=1' followed by what ever the query required.