One to many Issue

Khaleelah · 2024-08-26T08:44:24+00:00

There was an error rendering this rich post.

Khaleelah

Hello,

Given that board recommends only many to one relationship / hierarchy.

Consider one to many below

Example

Item ——— Company

Company member 1 is parent to Item number 1

Company member 2 is also parent to item number 1

(Relational DB representation below)

Item Company

1 1

1 2

So this scenario is not possible in board. Is the only solution we have is to have two or more Company Entities ? like below

Item Company 1

1 1

Item Company 2

1 2

Thank you

Find more posts tagged with

Accepted answers

Leone Scaburri

Hello @Khaleelah,

the example you described is not a relationship since item and company are not in a hierarchy but should be managed as stand alone dimensions in a cube.

Helmut Heimann

https://community.board.com/discussion/comment/18343#Comment_18343

It is Best Practice since there is no other way ;-)

All comments

Helmut Heimann

Hi @Khaleela,

the typical solution to your requirement would be to set up a mapping cube with Item and Company as separate (not linked to each other) dimensions.
Each valid combination of the two dimensions would be populated with a "1".

Best
Helmut

Khaleelah

Thank you Helmut.

It is the best practice?

Leone Scaburri

Hello @Khaleelah,

the example you described is not a relationship since item and company are not in a hierarchy but should be managed as stand alone dimensions in a cube.

Khaleelah

Agree @Leone Scaburri Thank you

Helmut Heimann

https://community.board.com/discussion/comment/18343#Comment_18343

It is Best Practice since there is no other way ;-)