Parent child list to ragged hierarchy

Options
jjwikselaar
jjwikselaar Member, ALL USERS, GroupMember, Employee, Certified Model Builder Posts: 5 Contributor
in Planning & Modeling

Hi, I am looking for a way to automatically create a ragged hierarchy for all possible combinations. The input is a simple file with only the parent - child combinations.

I've attached a screenshot of the parent child combination and how the ragged hierarchy should look like.

 

I think it is possible to do this when I combine the parent child list and ragged hierarchy list in one module and then create each level step by step, but I would like to avoid combining the 2 dimensions as the list will be extremely large!

 

Any ideas / suggestions?

Thanks,

JJ

Tagged:

Comments

  • jjwikselaar
    jjwikselaar Member, ALL USERS, GroupMember, Employee, Certified Model Builder Posts: 5 Contributor

    Thanks for the link @rob_marshall , but I should have been clearer in my description.

    In my case it will be a many to many relations. It is for a bill of material setup.

     

    For example:

    F1 (Finished good) need components: C1, C2

    F2 (Finished good) need component: C1

    C1 component need component: C3

    So in this case C1 has parents: F1 and F2

     

    To create ragged hierarchy I need to find all possible combinations, which are:

    F1

    C1-F1

    C2-F1

    C3-C1-F1

    F2

    C1-F2

    C3-C1-F2

  • jjwikselaar
    jjwikselaar Member, ALL USERS, GroupMember, Employee, Certified Model Builder Posts: 5 Contributor
    Thanks, that is very useful!
    It is needed though to have the dimensions (BOM and children) combined in one module which might result in a very big model.... but I guess we need to accept that.
    Will try to set it up like this to see what happens!

Categories