Forecasted Cost in the DWH is incorrect FCST_COST field in the DWH_INV_SUMMARY_FACTS Unplanned Lines

book

Article ID: 106166

calendar_today

Updated On:

Products

CLARITY PPM FOR ITG CLARITY PPM FEDERAL Clarity PPM SaaS - Application Clarity PPM On Premise

Issue/Introduction

The Forecasted Cost being reported by the DWH in the reports is not correct.

Based on the description of the FCST_COST field in the DWH_INV_SUMMARY_FACTS table, this field should provide this:

“Total forecast cost for the plan that is the plan of record. Equals actual_cost if the period is past, plan_cost if the period is current or future.”

However, the value does not include Unplanned Lines for past periods.

Steps to Reproduce:

1. Create a cost plan with planned lines. Make sure you have some periods in the past.
I grouped mine by resource and transaction class then used a different transaction class on one transaction to make the unplanned line.

2. Post transactions
a) One to match the planned lines
b) One to a different value (transclass) so you get an unplanned line.

3. Run Load DWH (I ran full)
4. Check dwh_inv_summary_facts
5. Check field FCST_COST


Expected Result: FCST_COST should include all actual costs for past periods plus planned for current month and future

Actual Result: FCST_COST does not include actual costs in past periods for Unplanned Lines.

Cause

The queries used to gather the Forecast amounts was not correct.

Environment

Affects 15.3 and 15.4

Resolution

DE40169 which is planned for fix in  15.5.