OTBI Dashboard Action Link Report Caching

Question

Hi all,

We have created an OTBI dashboard with multiple performance tiles. These performance tiles contain action links to detail reports that return ~30 columns of specific information. Is there any way to cache the results after the detail report has been generated, so that if you exit back to the dashboard and click the same tile (with the same parameters, same data, etc) the detail report query does not execute again?

Thanks!

Riyaz Ali-Oracle · Answer

Navigate to the Advanced tab in the analysis editor and ensure the Bypass BI Presentation Services Cache option is unchecked to allow cached data to be displayed.

Set DISABLE_CACHE_HIT=1 in the Advanced tab to prevent unnecessary re-execution.

Check this:

Advanced Techniques: Set Caching Options for Your Analysis

Cache — Oracle Analytics

Latest data changes not reflecting in OTBI report immediately — Oracle Analytics

Advanced Techniques: Set Caching Options for Your Analysis

MandeepGupta · Answer

Hi @Raghavendra Raghunath-Oracle ,

Hope you are doing well. Are you please able to help here?

Thanks.

TrevorD · Answer

Hi @Bhaskar Konar, I have reviewed that document. The advanced settings seem to be on bypassing the cache, but we are looking if there is a way to utilize the cache with action-links on reports. Right now with the default cache settings, (not bypassing the cache), when you click an action link the analysis query executes, then if you return to the dashboard and click on the tile (action link) again the query executes again. It does not cache the results from the first run. We are wondering if it is possible for those results to be instantaneous the second time you click the action link.