About Pipeline Parameters
The pipeline parameters apply to all functional areas.
- Data Refresh Schedule: Specify the frequency and when you want the incremental data load to happen. While specifying the timezone, the recommendation is to use city names to handle the daylight savings. For example, instead of selecting timezone such as EST or PST, select Europe/Bucharest or America/Los_Angeles. In this case, the data refresh process calculates the value mentioned in the Time field based on the local time irrespective of daylight savings.
- Analytics Language: Specify the language in which you want the data to be extracted. The language that you can select in the Analytics Language parameter is based on the initialized Oracle Fusion Cloud Applications languages. You can only select one language at a time. Changes to this global parameter don't take effect immediately even after next refresh and may cause inconsistent results because the refresh brings in only the incremental data in the selected language. You must reset the warehouse to ensure that the changes are effective.
- Analytics Currency: Currency conversions are required because your business might have transactions captured in multiple currencies. To create meaningful enterprise-wide analyses, you must use a common currency. Oracle Fusion Data Intelligence allows you to specify an analytics currency to store amounts in the data warehouse using this common currency. The load process checks the specified currency value and determines the corresponding exchange rate based on the exchange rate basis defined for each subject area to convert the amounts to the analytics currency. You can review the details of the exchange rate basis used in each subject area in the respective subject area metric details page. Analytic currency isn't a substitute for translation or reporting ledger specific requirements related to Reconciliation or Statutory reporting. For example, if your organization is a multinational enterprise that has its headquarters in the United States, you probably want to choose US dollars (USD) as the analytics currency.
- Exchange Rate Type: Specify an exchange rate type that you want to use when converting the transaction amounts to the analytics currency. For example, you may set up Corporate as a standard exchange rate across your organization for a stable currency.
-
Initial Extract Date: Initial extract date is used when you extract data for a full load. After extracting the data for a functional area, avoid changing the initial extract date. If you need to change the initial extract data, then after changing the date, reset the data warehouse and reactivate the functional areas. See Reset the Data Warehouse.
You can specify an absolute date from which to load the transaction data or a relative period to load transaction data within the effective period. The system uses the absolute date to process and load transactional data created after the initial extract date to the warehouse. It reduces the initial data load volume, however, with time the historical data volume can keep on increasing. In such a scenario, specify a relative period because with this approach, you can refresh data for the moving window of the specified period. For example, if the relative period is 3 years, the effective extract date moves every day to consider only data for 3 years. As part of application upgrade, the system cleans up the data warehouse based on the relative initial extract date that you specify. The Relative Initial Extract Date option enables you to store only the required amount of data in the data warehouse; thereby improving performance and avoiding additional costs due to large amount of historical data in the data warehouse.