Clarity

  • 1.  Cost Plan Detail - Time Varying Attribute in DWH

    Posted Apr 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

    Broadcom Employee
    Posted May 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'>