Hierarchical Relationships

[Anonymous]

Hi folks ,

I have a big hierarchy which is working fine .The hierarchy tables are linked like this hierarchy_1[nodeID]  1----->* hierarchy_2[parentID].

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 .

dddd

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]

hi, @Anonymous 

I'm a little confused about your description,

Since you want to link casefiles with all hierarchy tables, you could just create a relationship with hierarchy_7 table, what is your expected output?

Best Regards,

Lin

[Anonymous]

Imagine this tables :

casefiles

nodeID          NumberCases

1                           2

2                           3

3                           1

4                           1

5                           5

hierarchy_7

nodeID              parentID

4                             10

3                              9

hierarchy_6

nodeID              parentID

9                             11

10                           12

5                             13

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

I hope this helps you visualize it 🙂 @v-lili6-msft 

[v-lili6-msft]

hi, @Anonymous 

Your data model is strange, I'm afraid it is difficult to create the relationship with all the 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 hierarchy tables then create the relationship with each column. It could not achieve.

So I suggest you optimize this data model.

Best Regards,

Lin

[Anonymous]

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