Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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 ...
Need Help
  • OwenAuger's avatar
    OwenAuger
    2 years ago

    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?

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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