Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Relationship Ambiguity

Hello Everyone,   I will try my best to explain my current problem with relationship ambiguity, i will start first with what im looking for   My task is to be able to create two slicers that can ...
Need Help
  • MFelix's avatar
    MFelix
    6 years ago

    Hi Anonymous ,

     

    In the screenshot you have relationship from many to many, that will bring the issues you are refering.

     

    You need to create dimension tables with unique values to link the 3 tables on a one to many relationship.

     

    Is the HPM Phase (CJI3 table ) the link to the Cost Phase (OW Data) if yes the dimension table needs to be the Cost Phase column.

     

    Regards,

    MFelix

     

MFelix's avatar
MFelix
Icon for Super User rankSuper User
6 years ago

Hi Anonymous ,

 

In the screenshot you have relationship from many to many, that will bring the issues you are refering.

 

You need to create dimension tables with unique values to link the 3 tables on a one to many relationship.

 

Is the HPM Phase (CJI3 table ) the link to the Cost Phase (OW Data) if yes the dimension table needs to be the Cost Phase column.

 

Regards,

MFelix

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks MFelix  it worked perfectly for both my filters ( Well ID & Cost Phase)