obieefans.com

Feed Rss

How to Disable Cache for One Specific Report

10.04.2011, OBIEE FAQ, by .
Go to Advanced tab of Report

–>Go to Prefix Section
–>Write the below command:
SET VARIABLE DISABLE_CACHE_HIT=1;
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.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>