Date range for transferred data

The date range for the data moved to the Operational Reporting database during the ETL process is determined by the values you specify for the ETL_START_DATE and ETL_END_DATE parameters. The start date of the fiscal year is determined the year you specify for the ETL_START_DATE value. 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
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 fiscal year is determined the year you specify for the ETL_END_DATE value. 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
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.