Advanced Reporting - Ad Hoc report Actual Cost not updating

Document ID : KB000098023
Last Modified Date : 21/06/2018
Show Technical Document Details
Issue:
Actual cost do not show the updated value when an Ad Hoc report is created using the Weekly Resource Actual Cost (DWH_RES_PER_FACTS_W_V.ACTUAL_COST) and resources have their rate updated in the rate matrix. Even though the WIP transactions have been verified to have the new rate, the Ad Hoc report in Advanced Report does not update. 
Resolution:
Make sure the following jobs have completed successfully:
1. Time Slicing 
2. Update Report tables
3. Load Data Warehouse Full Load
4. Load Data Warehouse Access Rights 
5. Rate Matrix Extraction 
6. Investment Allocation 
7. Update Earned Value and Cost Totals 

If those jobs mentioned above have completed successfully and the issue continues to persist; run the following commands: 
1. admin update jasperParameters 
2. admin jaspersoft syncPPMContext -userName superuser -password superuser