Planned Cost and Budget Cost Total not populated in DWH_INV_SUMMARY_FACTS

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. 

The facts table data is based on Fiscal DWH time slice requests. 

Additional Information

See also: Load DWH job frequently reported issues