Clarity PPM

Expand all | Collapse all

Cost Plan Detail - Time Varying Attribute in DWH

Jump to Best Answer
  • 1.  Cost Plan Detail - Time Varying Attribute in DWH

    Posted 04-17-2019 06:39 AM

    I have created a time-varying attribute in the Cost Plan detail object to capture the committed costs of the project on a monthly basis. I have marked that attribute to include in DWH and executed full load data warehouse job. I want to include that as part of domain and use in ad-hoc reporting. I am trying to figure out which DWH table holds this information? 

     

    Screenshot: the way I am planning to capture commitments in cost plans:

     

     

    Regards

    Praneeth



  • 2.  Re: Cost Plan Detail - Time Varying Attribute in DWH
    Best Answer

    Posted 05-06-2019 08:38 AM

    Praneeth,

     

    I believe it goes into dwh_costplan_facts

     

    You can check by querying 

     

     select * from dwh_meta_columns  where src_column_name = '<enter the ID of the attribute'>