Jaspersoft Weekly Actuals Are All Zero

Document ID : KB000125143
Last Modified Date : 28/01/2019
Show Technical Document Details
Issue:
In Jaspersoft reports and adhoc views, the Actuals are all incorrectly showing as zero when run by week. However, running the same report by month displays the expected non-zero amounts. 
Cause:
This can occur if there is a mismatch between the week day on the From Date of the WEEKLYRESOURCEACTCURVE time slice and the First Day of the Work Week setting. 
Resolution:
The From Date on the WEEKLYRESOURCEACTCURVE (id: 55556) slice under Administration - Time Slices needs to be updated to match the First Day of the Work Week setting under Administration - Project Management - Settings. For example, if the First Day of the Work Week is set to Monday, the From Date on the time slice needs to be changed to start on a Monday as well. 

After this change is made, the following jobs need to be run in this order: 
1. Time Slicing job
2. Update Report Tables job - with the Update Reporting Calendar option checked
3. Load Data Warehouse job - Full Load
Additional Information:
CA PPM Tuesday Tip: How to Set Up the DWH (Data Warehouse) time slices to avoid errors with the 'Update Report Tables' and 'Load DWH' jobs