Confused why I am getting the ambiguity message when creating a relationship?

[Spudder112]

I am trying to make the highlighted relationship active, I figured I would be able to, since everything is flowing in one direction. Any ideas why that is not the case?

I am trying to be able to show orders by market by customer by driver.

[HotChilli]

Error message is correct. I can see 2 paths from Market to DimOrder.

---

You can

1. Alter the model by having 1 or more inactive relationships and activating them in the appropriate measure used

or

2. Possibly use a copy of Market table and break the link that's causing the error.

--

You might need to rethink the model anyway. I can see many-to-many relationships and 'bridge' tables that probably aren't needed.

[Spudder112]

I don't think there are any "many to many" relationships. However, I agree the Market section of the modelling probably needs an overhaul, which is the long-term goal, and my short-term fix seems to not be the correct approach.

Thank you!

[HotChilli]

"to make the highlighted relationship active" - Can't tell which relationship from the picture. Can you clarify?

Post the error message too.

- This is the error message that means you have 2 paths to get to the same table, so that'll be the issue

[Spudder112]

The highlighted relationship is the one to many between Market and Driver Market Mapping

Error Message:

Also if possible, how could this be corrected to filter DimOrder correctly by Market through both DimDriver and DimCustomer?