Forecasted Cost in the DWH is incorrect FCST_COST field in the DWH_INV_SUMMARY_FACTS Unplanned Lines
Article ID: 106166
Updated On:
Products
Clarity PPM SaaS
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.
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.
Feedback
Yes
No
Powered by
