Planned Cost in DWH is different compared to PPM

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

When there is an investment spanning for longer durations, the planned cost which is shown in PPM(FIN_FINANCIALS or FIN_PLANS) is different to what is stored in DWH(DWH_INV_SUMMARY_FACTS) tables.

Reports might not be accurate.

Environment

Release : 16.0.0

Component : CLARITY DATA WAREHOUSE

Cause

The facts table data is based on Fiscal DWH time slice requests. By default the number of periods are 73 which translates to 2 Years into the past from the current month and 4 years into the future. 

Since only few periods are being loaded to DWH, the planned cost is only being summed up for the periods that are present.

Resolution

A viable workaround would be to increase the number of periods for the Fiscal DWH slices. However, this would have negative impacts in DWH load Performance and time slices performance.