Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 213 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
OTBI Dashboard Action Link Report Caching
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!
Answers
-
Hi @TrevorD,
Welcome to the Oracle Analytics community.
Please take a look into the following document which might be useful.
Hope this help.
Thank you.
1 -
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.
1 -
0
-
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
Latest data changes not reflecting in OTBI report immediately — Oracle Analytics
0
