How is the report cache is cleared in FDI after the Incremental data loads are completed. Cache is cleared automatically or do we have to do manually clearing the cache after the Incremental data loads. How long cache retain in FDI.
@User_8NMCW BI Report cache is not cleared automatically post the pipeline loads. You may need to plan to purge your cache regularly in order to avoid stale data on reports.
Please refer the below KM note which talks about one of such ways to do it,
How To Programmatically Clear Cache in Oracle Analytics Cloud(OAC) using JDBC [Video Content] (Doc ID 2956513.1)
Hi Ashish,
Thank for the reply,
how it will be for FDI?
@User_8NMCW Clearing BI cache operation is always performed on the OAC side, irrespective of the OAC being standalone or integrated with FDI. And since there are no automatic cache clearing mechanism from FDI side related to OAC, Customers are suggested to plan their BI cache purge in any way feasible for them.
Above document is an example of how to do it, there can be other ways of doing the same as well ie. Creating a agent schedule which runs the cache purge operation before the end of pipeline runs or at the start of the business day etc.
I have raised SR On this, The reply I have received from Oracle is : When the FAW pipelines are finished the cache will be purged automatically in the backend and you need not explicitly issue the purge cache from DV. Also, If by any chance the pipeline fails and you manually restart or resubmit the pipeline and after pipeline is successful completed the cache will also be purged.
the thing which you said is different which one is correct?
@User_8NMCW My update is based on the understanding that the Pipeline loads are run to load the Warehouse tables where as the Report data is picked up from BI Server cache. Can you provide the documentation reference provided in this SR confirming your last statement?
Hi Ashish
Sorry I have not received any documentation
from
viswa
Explore how to build agents using code in AI Data Platform. We'll create an agent that examines and analyzes the contents of a Github repository and reports its findings. The session demonstrates how to use different developer tools to create agents including the AIDP extension for VS Code and Codex. Using these tools we…
Hello Team, In the fusion source, we have the records maintained in multiple language say in english as well as in arabic.. ex: dept name is stored in both english and arabic in oracle fusion source with 2 records with different language code like EN and AR. But the same data in FDI is getting extracted only with the…
Hi Team, can oracle provide a standard decks to have a demo and presentation with new customer? Please share any links or attachments if available. Thanks, Manoj
hello, Is there a way to hide the "back" button in the FDI menu bar? Thank you in advance for your help!
HI, I am trying to get data from the Enterprise Contracts - Contracts subject area in FDI. However, it is not returning any records when I use this subject area. Are there additional configurations or setup tasks needed to pull enterprise contracts data in FDI? I have checked the following: In Oracle fusion, I have access…
