1. Administering Oracle Fusion Analytics Warehouse
  2. Configure Oracle Fusion Analytics Warehouse Data
  3. Set Up the Pipeline Parameters

Set Up the Pipeline Parameters

Set up the pipeline parameters for your data model file before running your data pipelines for the functional areas.

Oracle Fusion Analytics Warehouse releases application updates at regular intervals that are visible on the Release Updates tile of the Console. See About Application Updates. Some of the application updates involve an upgrade of the underlying data model. If a data model upgrade is available at the time that you specify for the daily incremental refresh, then the data model upgrade overrides the incremental refresh for the day. The data model upgrade is a lengthier process and the data refresh for the specific day may take much longer than the regular daily incremental refresh.

Any country that exercises time change forwards the time by an hour. For example, in the U.S.A., standard time changes to day light saving time on 2nd saturday of March, forwarding the time from 2 am to 3 am. As a result, any refresh schedules set between 2 am to 3 am of a day won't execute on that day. If you need to guarantee daily refresh, then ensure to schedule it either before 2 am or after 3 am.

  1. Sign in to your service.
  2. In Oracle Fusion Analytics Warehouse, open the Navigator menu, click Console, and then click Data Configuration under Application Administration.
  3. On the Data Configuration page, under Global Configuration, click Pipeline Settings.
  4. On the Pipeline Settings page, from the Analytics Language list, select the language in which you want to extract the data.
  5. From the Analytics Currency list, select the currency of the transaction data.
  6. From the Exchange Rate Type list, select an exchange rate type that you want to use when converting the transaction amounts to the global currency.
  7. In Initial Extract Date, select the date from which to load the transaction data.
  8. Under Data Refresh Schedule, from the Interval list, select the frequency of the data refresh. Depending on the selected interval, specify the time, day, and month when you want the incremental data load to happen.
  9. Click Save.