Ambiguous paths in conception

[Anonymous]

Hello ! 

I currently have a Sales fact table I can analyse through by many axis, among which Date and Country, but I want to add an axis that would allow me to analyze the sales depending on the Marketing Campaign that was running when and where the sale was made.

Here's the conception I currently have : 

But I get an error message telling me that there are ambiguous paths between Marketing Campaign and my Sales table. I can see why, but I can't quite figure out how I could solve this without directly linking it with my fact table (which I'm trying to avoid since this is a simplified version and in reality I'd have to modify 10 different fact tables to link them).

Is there any way I can achieve this conception ? I currently have a many to one link between MC and Country/Date (filter on both tables), as well as a many to one link between Sales and Country/Date (filter on Sales).

Thanks in advance,

Nossair

[amitchandak · Accepted solution]

@Anonymous , Make sure joins are single direction 1- M from Date or Country to Sales or Marketing Campaign.

Bi-Directional join's can create a loop, hence this error

[Anonymous]

Hi @amitchandak ,

When you're talking about 1-N / bidirectional, are you talking about the cardinality of the relationship or the direction of the filter ?

Thanks,

Nossair

[v-xiaotang]

Hi @Anonymous 

"1- M" ——> one to many😃, i.e.  the cardinality of the relationship

-

Have you solved this problem? If yes, could you kindly accept the answer helpful as the solution. so the others can find it more quickly. thanks

Any question, please let me know. Looking forward to receiving your reply.

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.