Clarity PPM

Expand all | Collapse all

PPM_DWH.DWH_FIN_PLAN_PERIOD_FACTS

Jump to Best Answer
  • 1.  PPM_DWH.DWH_FIN_PLAN_PERIOD_FACTS

    Posted 06-07-2018 11:14 AM

    Hi,

     

    We have investments (projects) that have actuals (Hours & Dollars) being booked against them, however, some are not being reflected in the  PPM_DWH.DWH_FIN_PLAN_PERIOD_FACTS table on the field  PF.ACTUAL_COST?

     

    We run the iterative Load Data Warehouse job during the week and the Full Job on the weekends.  Any thoughts as to why we would not see expenses in the data warehouse and other projects do reflect the actual costs?

     

    Thanks



  • 2.  Re: PPM_DWH.DWH_FIN_PLAN_PERIOD_FACTS

    Posted 06-07-2018 12:07 PM

    Hi Jonathan

     

    Can you run the full load and see if that populates.


    Regards

    Suman Pramanik 



  • 3.  Re: PPM_DWH.DWH_FIN_PLAN_PERIOD_FACTS

    Posted 06-11-2018 05:30 PM

    Hi Jonathan

     

    This issue sometimes happens when the Incremental Data Warehouse job is running and a user goes and modifies a cost plan. If they did it when the job was running, the changes will not make it in DWH. 

    So I agree, try running the Full Load, this will update the records. Then if you scheduled Incremental very often during the day, I would suggest to space it out. 

     

    If you still see some data missing after that, please feel free to raise a Support case with us.

     

    Thank you -Nika



  • 4.  Re: PPM_DWH.DWH_FIN_PLAN_PERIOD_FACTS

    Posted 06-12-2018 01:35 AM

    Along with it, in DWH you get only Plan of Record if the option is checked 

     

     

    Can you also check if the POR is checked or unchecked and then run the DWH to confirm

     

    Regards
    Suman Pramanik 



  • 5.  Re: PPM_DWH.DWH_FIN_PLAN_PERIOD_FACTS
    Best Answer

    Posted 06-27-2018 08:37 AM

    Hi,

     

    After conversing with CA Support, this has been labeled as a defect.

     

    Thanks