Share this page

# Date range for transferred data

This topic introduces the date range for the transferred data.

In this topic:

## Date range for transferred data

The data moved to the Operational Reporting database during the ETL process follows a date range specified by the ETL_START_DATE and ETL_END_DATE parameters. However, the start and end dates of the PPM center fiscal year determine the actual start and end dates for the ETL process.

- The start date of the PPM center fiscal year determines the year you specify for the `ETL_START_DATE` parameter.

  Table 7-1. Effect of PPM Center fiscal year on the calculated ETL start date shows how this influences the actual start date for the ETL.

  Table 7-1. Effect of PPM Center fiscal year on the calculated ETL start date
  Specified ETL_START_DATE | Start Date for the OpenText PPM Fiscal Year | Calculated (Actual) ETL Start Date
  --- | --- | ---
  01/15/2008 | January 1 | 01/01/2008
  | November 1 | 11/01/2007

- The end date of the PPM center fiscal year determines the year you specify for the `ETL_END_DATE` parameter.

  Table 7-2. Effect of PPM Center fiscal year on the calculated ETL end date shows how this influences the actual end date for the ETL.

  Table 7-2. Effect of PPM Center fiscal year on the calculated ETL end date
  Specified ETL_END_DATE | End Date for the OpenText PPM Fiscal Year | Calculated (Actual) ETL End Date
  --- | --- | ---
  11/30/2012 | December 31 | 12/31/2012
  | October 31 | 10/31/2013

## Date range for transferred Time Management data

For Time Management data, the value set for the `ETL_START_DATE` parameter determines which time sheets' data are brought into the Operational Reporting database. If a time sheet has an end date that is on or later than the `ETL_START_DATE,` then that time sheet is used to generate data in the Operational Reporting schema.

The `ETL_END_DATE` parameter value is not used. Except for cancelled time sheets, all time sheets with end dates that fall after the ETL start date are brought over.

## Date range for transferred Resource Management data

Calculated ETL start and end dates affect Resource Management data transfer in the following ways:

- Fiscal period definitions are brought over for fiscal periods whose start dates and end dates fall within the time period specified by the calculated start and end dates.

- Resource demand data are brought over for all staffing profiles whose demand falls within the time period defined by the calculated start and end dates.

- Resource capacity data are brought over for all of the resources for the time period between the calculated start and end dates, provided that the resource's end date is later than the calculated end date, and the resource's start date falls within the time period specified by the calculated start and end dates.

- Resource actual effort data are brought over for all the time sheets (excluding cancelled time sheets) with ending dates later than the calculated start date.

  Caution: If you have long-running projects, keep in mind that requests created before the ETL start date you specify are not brought over, and so the actual effort data for these requests are not available for reporting.

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: