Set Up the Pipeline Parameters

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

  1. In Oracle NetSuite Analytics Warehouse Console, click Data Configuration.
  2. On the Data Configuration page, under Configurations, click Pipeline Settings.
  3. Under Data Refresh Schedule, select the interval and depending on the selected interval, specify the time, day, and month when you want the incremental data load to happen.
  4. Under Data Maintenance Schedule, schedule full data loads separately to avoid affecting the incremental refresh.
  5. In Initial Extract Date, select Absolute or Relative as Date Type and provide these details:
    • If you select Absolute, provide the date from which to load the transaction data.
    • If you select Relative, provide the period in Relative Period and select either Days, Weeks, Months, or Years.

      Note:

      The system displays the "Effective Date”. The effective date indicates how far back the data is available in the warehouse. The warehouse may have data beyond the relative period. In the next application update, the system deletes this older data.

      Relative initial extract date details

  6. Click Save.