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.
Release : 16.0.0
Component : CLARITY DATA WAREHOUSE
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.
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.