Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
I have three fact tables - Case Listing, Job Listing and JoBGRA Listing. All these have a column called Postal Code.
There is a dimension table Dim Zones with Postal code and additional attributes.
1. Case Listing --> Dim Zones on Postal Code --> Many to 1 relationship SIngle Cross filter direction.
2. Job Listing -- > Dim Zones on Postal Code --> Many to 1 relationship SIngle Cross filter direction.
Both are active.
3. Job GRA Listing -- > Dim Zones on Postal Code --> Many to 1 relationship SIngle Cross filter direction.
When trying to activate the third relationship get error message
The 3 tables do not have any relationship between them.
Unable to understand the reason for the error.
Appreciate any help.
Cheers
CheenuSing
Solved! Go to Solution.
At a glance it looks like the relationship between Dim Executives and Job GRA Listing may be contrinbuting to the problem.
Can you change this relationship direction so Dim Executives filters Job GRA Listing?
Hi @OwenAuger ,
Any pointers for this.
Best Regards
CheenuSIng
Hello @CheenuSing ,
because you have cross filter relationships, can you show us all the schema?
Proud to be a Super User! | |
Hi All,
Just to add I have active relationship of the 3 tables on column executives with Dim Executives table.
And it is perfectly working.
Cheers
CheenuSing
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |