When updating descriptive flexfields in FDI > Custom Data Configurations, there are actions to Reload Data or Refresh Data. What is the purpose of these actions? I cannot find documentation on it.
@Molly P Reload Data will essentially perform a full load for the DFF related tables but the Data will reload in next scheduled data refresh. But a Refresh Data will perform an adhoc incremental load for the DFF related tables, you dont have to wait for the next schedule data refresh.
As Ashish says, for reloading data from source. Reload in effect wipes the warehouse and repopulates for that data entity, where as refresh is an incremental load.
If I'm doing any development, e.g. meta data changes such as enabling multiple DFFs and especially disabling DFFs I'll do a reload just so I know I have a known baseline to report from.
As Ashish says the refresh option is for incremental on demand rather than waiting for the next schedule. If I'm say doing mass updates to DFF values in Fusion apps and testing a report I'd do a refresh to bring in the changes as that will get me a quick turn around rather than waiting for next ETL.
Thank you both. @Richard Halford is there a limit to how many incremental refreshes we can do?
Thanks, Molly
I've not had any limit on how many I can run other than how long it takes to get a processing slot and run the incremental.
With your pipeline you can set frequent refresh for some tables as hourly as an example and I can see in there you can select DFFs (though I would expect your need to have the related table in frequent refresh to get in new records else I would suspect its doing updates only)
If you are running a DFF incremental on demand via refresh I'd expect you can get runs, maybe two in within an hour depending on how much data you changed. I did a complete republish of DFFS (in effect re-generate the RDP extension clean down and reload data) in about 1 1/2 hrs including a full reload.
Hi, the reload does not affect any custom schema but only the oracle schema, correct?
Is there any way to trigger a full reload of the Oracle Schema? Or does it have to be done for every Application (Offering & Functioanl area)?
Thanks
@JT_DC_2023 Instead of doing a reload of the functional areas. You can either "Reset the Data Warehouse" or "reset and reload"
https://docs.oracle.com/en/cloud/saas/analytics/24r3/fawag/reset-and-reload-data-source.html
https://docs.oracle.com/en/cloud/saas/analytics/24r3/fawag/reset-data-warehouse.html
The "reset and reload" function does not affect custom tables, right? It will only reset and reload the out of the box data?
@JT_DC_2023 Reset and Reload option will affect all the activated functional modules , Augmentations and Custom Data Configurations ie. DFF, CAA etc If your Custom tables are not brought in using Augmentations then they won’t be affected
Hi team, I have a question: can I do several refreshes a day for a table created with Data Augmentation? This is for version 24.R4.P2 of FDI. Thanks
Hi, do both options have the same purpose for Custom Data Configuration and Data Augmentation ? Or it differs ? Thanks so much
Description: The Oracle Fusion Data Intelligence (FDI) Product Roadmap Update provides an overview of the latest developments and future plans for FDI. Oracle Product Management experts will share upcoming capabilities, key enhancements, and product direction, helping attendees understand what is changing and how these…
How to show amount columns with currency symbol and format in AI Agent response. Provided sample in supplement instruction but it is not displaying based on format
After the recent Oracle FDI/OAC release updates, both our PROD and DEV environments no longer display the Data | Visualize | Present tabs at the top of the workbook.Previously, I used the Present tab to: Hide or show specific canvases/visualizations. Hide filters used in the workbook. With the new workbook interface, I…
We are trying to clarify the 2 data sets that go into the oracle-delivered "Headcount Turnover" measure. This measure is found in FDI, in "HCM - Workforce Core"."Facts - Workforce Headcount" subject area We have our own internal calculation, which is a few percentage points different than this measure, which is why we are…
My data: My Calculation - above in the last column you can see it works great: So why the heck my table goes blank for every value in Month End Date filter?
Dear Experts, We are trying to add security steps to our new implementation but the option that is mentioned in oracle documentation and also seen on other existing implementations is not available in our instance. The Navigation is FDI Console> Semantic Model Extensions> Security Configurations> Data Security Step.…
