This content has been marked as final. Show 1 reply
Go to advance tab of the report, in the prefix section type set variable disable_cache_hit =1; and check the Bypass Oracle BI Presentation Services Cache checkbox.
This will disable the cache for that particular report. You can follow the link below.
One more solution
Add a dummy column to your report with CURRENT_TIMESTAMP in the formula. Hide this column.
Now your report will never generate cache.
Edited by: Maqsood Hussain on Dec 9, 2012 5:10 AM