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

book

Article ID: 219427

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

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

Cause

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.

Resolution

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