ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Actual Cost and Planned Cost wrong in Data Warehouse (DWH)


Article ID: 120679


Updated On:


Clarity PPM SaaS Clarity PPM On Premise


Actual Cost and Planned Cost are showing wrong in the Data Warehouse (DWH) in Clarity. As a result, this data is showing wrong in reports such as the Jaspersoft/Advanced Reporting Project Storyboard Report.


Release: All
Component: Data Warehouse (DW)


Reslice the DWH slices. To do this:

  1. Pause the Time Slicing job (and wait for any processing time slicing jobs to complete) 
  2. Go to Administration -> System Options -> Data Warehouse Options
  • Clear out the field: 'Entity for Fiscal Periods' and click Save
  • Reset the 'Entity for Fiscal Periods field back to the previous Entity value and click Save again. 

     3. Unpause the Time Slicing Job (Check the check box next to the Paused Time Slicing job and click 'Resume') and wait for the job to complete successfully. 


  • If you go to Administration > Data Administration > Time Slices page, you will see that the DWH time slices "Last Run Date" have cleared out indicating they will now be reprocessed by the next Time Slicing job. 
  • It may take longer for the Time Slicing job to complete the first time after the reslice. 
  • After the Time Slicing job instance completes, run the Load Data Warehouse (DWH) job in full mode. 

Additional Information

Reference also: