Building relations

[dr_anas]

I need your assistance to fix the relationship between the two tables in the screenshot.

I need to establish a relationship with the bonus table, and I have a fact sales table, but it is arriving many to many, and I need it one to many.

Kindly be advised that:

1- Since items might be found in multiple departments, department IDs are duplicated.

2- Because it contains various quantities as a bounce in different months, the item is duplicated.

[Idrissshatila]

hello @dr_anas , 

in order to help you, we need to understand the logic about the relation between the fact sales and the bonus table.

[dr_anas]

The logic goes like this: the number of bonuses quantities for each item over the date has to be computed. Each item has a bonus with zero value quantities sold throughout the year.

I wish it is clear now If not, please let me know so that I can clarify more.