One to many Issue
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
Accepted Answers
-
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.
1 -
It is Best Practice since there is no other way ;-)
1
Answers
-
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
Helmut0 -
Thank you Helmut.
It is the best practice?
0 -
Agree @Leone Scaburri Thank you
0