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

Environment

All versions

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

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

Make sure that the Fiscal Time Slices cover the Financial Plan and Budget dates.

This also includes using the Financial Summary values and not detailed Financial plans.

Additional Information

See also: Load DWH job frequently reported issues