Ambiguity - 2 Similar Scenarios

[Anonymous]

Hi, I'm kind of mind boggled. I have a major table: DEVPROT_MASTER2 that I'm trying to connect to differerent tables, and perform calculations. 

In the first scenario I would like to perform a calculation based on YYYYMM and segment. Hence I created 2 reference tables of that sort and connected my DEVPROT_MASTER2 table and my HUP table to them, all Single filters going from the reference tables to the core tables.

In my second scenario, I do the same thing. I clone my 2 reference tables and to avoid errors, I import the DEVPROT_MASTER2 table again to do a separate calculation with the EBU_NAC table.

However when I try to make the last relationship join I receive the following error.

'There are ambiguous paths between 'EBU_NAC' and 'SegmentTable (2): 'EBU_NAC'->'MonthTable2'->'DEVPROT_MASTER2 (2)'->'SegmentTable (2)' and 'EBU_NAC'->'SegmentTable (2)'

How is that possible when I just did the same exact joins with the same exact reference tables in Scenario 1?

Scenario 1Scenario 2

[Anonymous]

All the relationships are set many to many and all the tables are connected. So if you filter on Segment in your scenario 1 there are two paths to get to your Month table, that's why its ambiguous. And that is also why your scenario 2 works. Try changing your Month and Segment tables to 1:M to each of the other tables, as month and segment appear to be dimension tables.