- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Building relations
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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! | |
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
04-24-2025 05:10 AM | |||
11-02-2024 04:15 AM | |||
02-08-2025 06:28 AM | |||
03-07-2025 01:07 PM | |||
06-11-2024 07:29 AM |
User | Count |
---|---|
70 | |
70 | |
34 | |
23 | |
22 |
User | Count |
---|---|
96 | |
94 | |
50 | |
42 | |
40 |