Hierarchical Relationships

Question

Hi folks ,&nbsp;I have a big hierarchy which is working fine .The hierarchy tables are linked like this hierarchy_1[nodeID]&nbsp; 1-----&gt;* hierarchy_2[parentID].&nbsp;&nbsp;My problem is whenever I have a table outside of the Hierarchy with different type of values but also with nodeID's , I want to be able to link it with all of the hierarchy . I can't because of ambiguity between relationships .&nbsp;dddd&nbsp;In case you didn't understood my question , I want to be able to link casefiles with all hierarchy tables without having ambiguity problems ..

v-lili6-msft · Answer

hi,&nbsp;Anonymous&nbsp;
I'm a little confused about your description,
Since you want to&nbsp;link casefiles with all hierarchy tables, you could just create a relationship with&nbsp;hierarchy_7 table, what is your expected output?
&nbsp;
Best Regards,
Lin
&nbsp;

anonymous · Answer

Casefiles has values in all tables of the hierarchy . My goal is to create a hierarchical tree map with values of casefiles , and if I only link the casefiles with the hierarchy_7 , on my tree map I will only get values from hierarchy_7 .

Appreciate your help v-lili6-msft

anonymous · Answer

Imagine this tables :&nbsp;casefiles&nbsp;nodeID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NumberCases1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 22&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 33&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 14&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;hierarchy_7nodeID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; parentID4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 103&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9&nbsp;hierarchy_6nodeID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; parentID9&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1110 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 125&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 13&nbsp;If I only link the hierarchy_7 with casefiles I will only get the values from the nodes 3 and 4 , and I still wanted the values from the hierarchy_6 from the node 5 ...&nbsp;&nbsp;I hope this helps you visualize it :) v-lili6-msft&nbsp;&nbsp;

v-lili6-msft · Answer

hi,&nbsp;Anonymous&nbsp;
Your data model is strange, I'm afraid it is difficult to create the relationship with all the&nbsp;hierarchy tables.
Usually, the lowest level table should have the complete substructure.
For your data model, It likes that use merge left join all the&nbsp;hierarchy tables then create the relationship with each column. It could not achieve.
So I suggest you&nbsp;optimize this data model.
&nbsp;
Best Regards,
Lin

Forum Discussion

Hierarchical Relationships

4 Replies

Related content

Hierarchal Relationships

Relationship

Relationships

Relationship Issue

Creating relationships