PPM: Reports start showing hours instead of FTE approximately 6 years into the future

Document ID : KB000029425
Last Modified Date : 14/02/2018
Show Technical Document Details


Reports don't show Full Time Equivalency (FTE) correctly in the month of February, five years into the future. Some reports hours. For some reports such as Investment Allocations and Assignments, Hours are displayed instead of FTE, for other reports, FTE is shown as 0 instead of expected value of 1. 

Steps to Reproduce:

  1. Create a project in Clarity, add assign a team member to a task with a Finish Date out past January 2020 (If the current year is 2015). 
  2. Run the Time Slicing job.
  3. Run the Update Business Objects Report Tables job with all parameters checked.
  4. Under Reports, click on the Investment Allocations and Assignments Report.
  5. Change Period type to Month and Unit Type to FTE.
  6. For Start Date select the radio button next to Specific Date (Example, Use 8/1/2018 so you can see the differences before and after 2/20).  
  7. Click Submit to run the report and observe the results.


This is working as designed. 

In CA Clarity PPM v13.x and v14.1, the RPT_CALENDAR table is populated by the 'Update Business Objects Table' job.  

In CA PPM v14.2, the RPT_CALENDAR table is populated by the 'Load Data Warehouse' job. 

This job is coded to populate approximately a 10 year period, beginning with Jan 1st, 5 years prior to the current year. For example, if the current year is 2015, the population of data will begin on January 1, 2010 and populate for 3650 days from this date; therefore ending just a few days full of a complete 10 year period for daily values.  It will populate 520 Weeks, 120 Months, and 40 Quarters. The FTE data values are computed based on the Availability Slice Data present for the application 'admin' user configuration for the date ranges in this job.

To request an enhancement to change the way this function behaves, you can add an idea on the CA Communities site. 

For v14.2, To learn more about Jaspersoft reporting and the Data Warehouse, reference the CA PPM Advanced Reporting and Database Schema Index