Forum Discussion
Relationship Issue between tables
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
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?
5 Replies
Hello Anonymous ,
because you have cross filter relationships, can you show us all the schema?
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?
