Clarity

 View Only
  • 1.  Custom Attributes in DWH Tables - Project Object

    Posted Jun 20, 2022 09:47 AM

    Hi All - When we create custom attributes on Objects we refer the ODF_CA tables.

    In DWH which table we will have these custom attributes? 

    Please advice.



  • 2.  RE: Custom Attributes in DWH Tables - Project Object

    Broadcom Employee
    Posted Jun 21, 2022 09:05 AM
    Jaya,

    For this one it all depends on what type of attribute it is.

    One way you can find what table attributes are in is to query 
    select * from dwh_meta_columns

    dwh_meta_columns is in both the ppm as well as the dwh schema so you should be able to query it from either place.

    On the ppm schema it has the attribute_code
    Note that lookups usually have 2 rows in the table.  One is the attribute and one ends with _caption 

    Here you can filter by object_code which may help.

    In general:
    Lookups may end up with a table name similar to the lookup ID
    Multi-valued lookups end up in dwh_cmn_mv_lookups
    Other string type attributes usually end up in the table similar to the name of the object.
    If the attribute is in a sub object it usually ends up in the table with name similar to the parent.


    ------------------------------
    Liz Williamson
    Principal Support Engineer - Clarity
    Broadcom
    ------------------------------



  • 3.  RE: Custom Attributes in DWH Tables - Project Object

    Posted Jun 21, 2022 09:11 AM
    Hi Liz - I have found the answer - I have made the attribute open for DWH, then DWH full load is completed, now DWH_INV_PROJECT table is having the attribute. ( we will see 2 new columns, one is <Attribute_id> other with <Attribute_id_key> ).


  • 4.  RE: Custom Attributes in DWH Tables - Project Object

    Broadcom Employee
    Posted Jun 21, 2022 09:23 AM
    Thanks for letting me know Jaya.
    I use the dwh_meta_columns table quite a bit to find where the attributes may be in the dwh.

    ------------------------------
    Liz Williamson
    Principal Support Engineer - Clarity
    Broadcom
    ------------------------------



  • 5.  RE: Custom Attributes in DWH Tables - Project Object

    Posted Jun 30, 2022 01:45 PM
    Hi Liz - I have a attribute on Resource object, it is checked for DWH, job is completed, I see that attributeid_key column in the table, where would i find the associated Lookup table ?

    Please advise


  • 6.  RE: Custom Attributes in DWH Tables - Project Object

    Posted Jun 30, 2022 01:50 PM
    Hi Liz - I found it - its DWH_LOOKUPS_V table


  • 7.  RE: Custom Attributes in DWH Tables - Project Object

    Broadcom Employee
    Posted Jun 30, 2022 01:58 PM
    Thanks for letting me know Jaya.

    There is usually a _LN table which is the object's associated language table and holds the translations for the lookups.

    On the data warehouse that is how the actually value then populates the text vs the key for your reporting.

    ------------------------------
    Liz Williamson
    Principal Support Engineer - Clarity
    Broadcom
    ------------------------------