Schedule Frequent Refreshes of Data

You may want to frequently refresh the data in these sample scenarios:

  • During the last five days of the month or every quarter, general ledger data changes quickly with updated entries more than once a day. In this scenario, a financial analyst wants to ensure taking more recent and accurate data into the analysis and report generation. Because some of the data pipelines can take several hours to execute from end to end, the frequency of refresh needs to be every 4 hours or 6 times in a 24-hour period.
  • In this scenario, a retailer that has strict guidelines for returns or refunds on any purchase orders, and needs to bring in the most recent order data for computation and report generation, especially in the beginning of a given fiscal quarter. To cover for time differences between Europe, East Coast, and West Coast of the U.S., a financial analyst needs to refresh data every 8 hours in 24 hours, or 3 times a day.

Ensure that Frequent Refresh is enabled in Pipeline Features under the Generally Available Features tab on the Enable Features page prior to scheduling frequent data refreshes. See Enable Generally Available Features.

  1. Sign in to your service.
  2. In Oracle Fusion Data Intelligence Console, click Data Configuration under Application Administration.
  3. On the Data Configuration page, under Configurations, click Pipeline Settings.
  4. On the Pipeline Settings page, click Frequent Data Refresh Schedule.
    Description of fawag_fdr_schedule.png follows
  5. In the Frequent Data Refresh Schedule tab, in Refresh Frequency (in hours), select the number of hours after which you want the data refresh to happen.
  6. Enter a start time in Start time.
  7. In Last refresh date, view the date when the data was last refreshed.
  8. If you've enabled the "Frequent Refresh Tables" preview feature and saved your selection of the warehouse tables, then select the Perform frequent refresh for selected warehouse tables toggle. Click the "warehouse tables" hyperlink to view or update your selection of the warehouse tables in the Frequent Refresh Tables tab.
  9. Select the check boxes for the functional areas with the data you want refreshed at the specified interval.
  10. Click Save.