Description: Currently, the options for setting up the FDI Datawarehouse Incremental Refresh are limited to selecting the frequency and the specific time when the refresh pipelines are triggered. It would be beneficial to enhance the system by allowing the FDI pipelines to be triggered based on the completion of a job scheduled in Fusion Application.

Proposed Enhancement: Enable the FDI data refreshes to occur dynamically in response to regular or predictable business events, such as daily posting, month-end close, paycheck processing, or inventory valuation, which affect when the data is ready for reporting. Specifically, the completion of the following three ESS jobs can be used to trigger the FDI Fusion ERP Analytics pipelines:

1. GL Posting Job
2. Project Performance
3. Transfer Balances to Essbase Cube

Benefits:

• Improved data accuracy and timeliness for reporting.
• Enhanced flexibility and responsiveness to business events.
• Reduced manual intervention and scheduling efforts.