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.
-
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.
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.