Hierarchy in PDP

Hi,

I have a report which contains the manager level information in the hierarchical way. How to implement the hierarchy structure in PDP using the report automatically and we need a way for the users to see who reports to who? and also the person can only see their reportees information when they login to the DOMO 

 

Thanks

Comments

  • jaeW_at_Onyx
    jaeW_at_Onyx Budapest / Portland, OR 🟤

    Domo doesn't really support data in a ragged hierarchy (i assume your table structure is 

    employee_id, emp_name, supervisor_id).

     

    You'd have to flatten your hierarchy into columns.

    L1 = CEO

    L2 = C-suite

    L3 = Managers

    L4 = Reports.

     

    Then you can create PDP policies based on those columns.  it's a pain.

    At that point, instead of thinking of PDP by individuals, maybe think of it as PDP by regions and territories or Department & Job function.  Usually, if you approach the project that way, the grain is a bit more manageable.