Go to Advanced tab of Report
–>Go to Prefix Section
–>Write the below command:
SET VARIABLE DISABLE_CACHE_HIT=1;
It will look like:
This will bypass the RPD cache for a specific report.
For bypassing Presentation services Cache you can check “Bypass Oracle BI Presentation Services Cache” check box.
By using these two options, we can manage Cache by disabling the report to hit the RPD or Presentation Services Cache. It will get the report data directly from the Database without passing through the any Cache.
