Clarity

  • Private Community

  • 1.  Delivery Unit details from PPM Dataware House

    Posted May 18, 2018 09:32 AM

    I'm building a Power BI Dashboard for Ideas using PPM Dataware house. Can someone tell me which table and column I should refer, to gather the details on Delivery OBS Unit. I need the only unit name, not the complete path.

     

    Thanks

    Priyanka



  • 2.  Re: Delivery Unit details from PPM Dataware House

    Broadcom Employee
    Posted May 21, 2018 11:08 AM

    HI Priyanka,

     

    Please try the tables below joined to your data and see what will be the best to display the information needed:

    DWH_CMN_OBS_HIERARCHY
    DWH_INV_OBS_MAPPING
    DWH_LKP_OBS_UNIT

     

    Hope this helps. 



  • 3.  Re: Delivery Unit details from PPM Dataware House

    Posted May 21, 2018 01:21 PM

    Hi Nika,

     

    Thanks for your help. I'm looking for the below Org names only. I need only these names. Please let me know if you are

    aware of Table and column name containing this info.