Help with Data Model: Ambiguity between tables triggered_send and event

[jervissho]

Hi everyone,

I am trying to get an active relationship established between triggered_send and event (together with send) following the Salesforce Marketing Cloud Schema here

https://docs.google.com/presentation/d/1F5eVIvE37fAfEvFQlT-2Y-a4qBikIy9W2hpOT7ZUdAw/edit#slide=id.g3...

It keeps prompting the same error despite renaming some of the fields. I am assuming the column names are still ambiguous?

I have also changed all the cross-filtering mode to single after going through the similar posts but still to no avail... I want to avoid using DAX as much as I can as this would be used by non data people.

Cheers!

[jervissho]

I am still faced with the same issue after deleting the rest of the links. I think the cause lies with email and event. Any chance i could make event reference to both triggered_send and send that is both needing to be reference from the email table?

[v-mengzhu-msft · Accepted solution]

Hi @jervissho ,

As the error shows, you can't create direct active relationship between "email" and "send" . You can uncheck "make this relationship active", let the email and send tables be connected as an inactive relationship.

Best regards,

Community Support Team Selina zhu

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

[AnkitDeswal]

Hi, 

This is because you have created 1 to * relationships between [List] - [Event] and [List] - [Triggered Send].

Two distinct paths are already specified for [List] to filter [Event] and [Triggered Send] tables.

So, if we try to make the [Triggered Send] - [Event] relationship active, it will create another indirect filter which will cause ambiguity in the data.

Due to this you cannot have another active relationship between [Triggered Send] and [Event] tables.