Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hierarchical Relationships

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 tabl...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

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's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
7 years ago

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