To disable cache for certain reports

To Disable cache for certain reports

Cache stores the queries of the reports that is generated by the user in OBIEE Application. Cache can be enabled in Enterprise manager or Config files.

To disable cache for certain reports:

1. Login into the application

2. Click Analysis and Select the Subject area from which dimensions and measures are taken for report             generation.

3. Under criteria tab, dimensions and measures are selected and appropriate filter is given for the report.

4. Click result tab for generating the result of the report.

5. Go to Advanced tab

     a) There will be an option found "Bypass Oracle BI Presentation Services cache" which will prevent the report from accessing the presentation services cache.

   b) Under prefix you need to mention the following

SET VARIABLE DISABLE_CACHE_HIT=1;

This would prevent report from access cache against the rpd.