1 Reply Latest reply: Dec 9, 2012 7:14 AM by Maqs-Oracle RSS

    Cache for Report

    978807
      hi,

      In Analytics for one report cache should available and for another report cache will not be available. How can we manage the cache for each and every report.

      Thanks,
      kumar
        • 1. Re: Cache for Report
          Maqs-Oracle
          Hi,

          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.

          http://www.obieefans.com/how-to-disable-cache-for-one-specific-report/


          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.


          Thanks

          Edited by: Maqsood Hussain on Dec 9, 2012 5:10 AM