Date range for transferred data

This topic introduces the date range for the transferred data.

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
    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
    PPM Fiscal Year

    Calculated (Actual)
    ETL End Date

    11/30/2012

    December 31

    12/31/2012
     

    October 31

    10/31/2013

Back to top

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.

Back to top

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.

Back to top