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.

Planned Cost and Budget Cost Total not populated in DWH_INV_SUMMARY_FACTS


Article ID: 219427


Updated On:


Clarity PPM SaaS Clarity PPM On Premise


The Planned Cost and Budget Cost in Clarity PPM is not matching with the data in DWH_INV_SUMMARY_FACTS


DWH_INV_SUMMARY_FACTS derives data from the slice tables. The Monthly slice periods were configured for 6 years but the Cost Plan and Budget Plan were going beyond the 6 year mark. Hence, the cost in this table will show only for 6 years and anything beyond that will not be shown.


You can extend the Monthly Slice periods further but this needs to done after thorough testing because extending the slice periods can cause performance issues. 

Additional Information

See also: Load DWH job frequently reported issues