Relationship Issue between tables

[Anonymous]

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

[Anonymous]

Hi @OwenAuger ,

Any pointers for this.

Best Regards

CheenuSIng

[OwenAuger · Accepted 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?

[Idrissshatila]

Hello @Anonymous ,

because you have cross filter relationships, can you show us all the schema?

[Anonymous]

[Anonymous]

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