Forum Discussion
Table relationship ambiguity
Hello Everyone,
I am facing an issue with the tables relationships.
I have 4 data tables CB,CB7,META and CALENDAR. Trying to create a relationship between all off these ,there is one relationship left i need to activate which is the META -> CALENDER.
i get a Relationship ambiguity error as picture attached.
I have tried changing filter directions, activating relationships in different orders but it didn't work.
Could anyone help ?
Relationships image:
14 Replies
The ambiguity occurs because you already have a relationship between META and CB7 tables, and there is a relationship between CALENDER and CB7. Creating a new relationship between CALENDER and META creates ambiguity. The same occurs with META and CB.
Ideally all date filters should come directly from the CALENDER table to the other 3
As PaulDBrown says you need to remove the existing relationship between META and CB7.
You need to delete the relationships between META and the other 2 tables before creating the relationships from the CALENDAR table
What fields do you want to link?
Hi Anonymous ,
Please remove CB->Calendar & CB7->Calendar and keep META->Calendar
This causes some data loss on the dashboard.
Video link -->https://aljazeeranet-my.sharepoint.com/:v:/g/personal/ramadasana_aljazeera_tv/EcLBb8tHlppHsbkI2aoJoycBGWx6xRuPkTTjzL5kLJno6g
Original file -->https://aljazeeranet-my.sharepoint.com/:u:/g/personal/ramadasana_aljazeera_tv/ERl-MZ0-j9RHh1YRqB8NZaQB42w3mAUh8l_M6EXz1FrEtA?e=IMG7bn
