Forum Discussion

MrTD's avatar
MrTD
Frequent Visitor
8 years ago

Relationships issues

Setup: I have a unique identifier in my 'Person' table labelled ID. These identifiers exist in two other tables 'Person Attributes' and 'Person Events' but are not unique.  I have a relationship set ...
Need Help
vcastello's avatar
vcastello
Resolver III
8 years ago

Hi MrTDI think your problem is due to the bi-directional relationship.

 

If you look closer at your photo you'll see that there are two arrows in each line of the relationship. This indicates that the relationship is bi-directional.

Change it to 'One Way'. 

You can do it through ....

1.- Open the relationship tab.
2.- Select one relationship.
3.-Click on edit.
4.- On the bottom-right of the page you'll see something like (I'm translating from spanish) ... Direction of the cross filter. Click there.
5.- Choose One Way.
6.- Click on accept.
7.- Repeat for the other one.

That should work

Hope That Helps

Vicente

  • MrTD's avatar
    MrTD
    Frequent Visitor
    8 years ago

    vcastello doesn't solve anything, thanks though!

    • vcastello's avatar
      vcastello
      Resolver III
      8 years ago

      Hi MrTD

      Then, I'm sorry :- (

      I don't know how I can help ...

       

      Vicente

      • SivaMani's avatar
        SivaMani
        Resident Rockstar
        8 years ago

        Hi MrTD,

         

         You have unique values on a table and it's detailed in another 2 tables.

        Let's take your sample data,

        Table1 - ID(unique values)

        Table2 - ID, Attribute

        Table3 - ID, Travelled

         

        Here is the issue,

        Attribute and Travelled fields are having text values so we can't aggregate them.

         

        Table2 is having 2 'a' values

        Table3 is having 3 'a' values

        obviously, the system can't detect the relationship between them. Suppose, any one of the tables has measures then it automatically aggregate it based on value 'a'

         

        I hope I made it clear.

         

        Let me know if you need further help.

         

        Regards,

        Siva