Jaspersoft Weekly Actuals Are All Zero


Article ID: 125143


Updated On:


Clarity PPM SaaS Clarity PPM On Premise


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. 


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. 


Release: CODFSS99000-15.3-PPM SAAS FedRAMP-Sandbox-Small Environment


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