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.
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.
Proud to be a Super User! |  |
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.
