Hierarchy in PDP

user069416
user069416 Member
edited March 2023 in Datasets

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

  • 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.

    Jae Wilson
    Check out my 🎥 Domo Training YouTube Channel 👨‍💻

    **Say "Thanks" by clicking the ❤️ in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"