Forum Discussion

Dayna's avatar
Dayna
Helper V
7 years ago
Solved

Cyclic relationship on table structure

Hi All,   I have two database tables: Server and Test Log   In the server table, I store some basic information about the server, for example, the date it was issued, the name, etc...   In the...
Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    7 years ago

    Hi Dayna,

     

    Sorry for late, I have reproduced your issue like below. For example, if you create a slicer based on one column in MasterCalendar table and select a value to filter DR TestingLog. There're two kinds of filter route, one is MasterCalendar-> DR TestingLog, another is MasterCalendar-> DR Server-> DR TestingLog. So there may be two different filter results in DR TestingLog which may cause ambiguity. 

      

     

    Regards,

    Jimmy Tao

     

v-yuta-msft's avatar
v-yuta-msft
Community Support
7 years ago

Hi Dayna,

 

Change the direction between 'MasterCalendar' and 'DR TestingLog', between 'DR Server' and 'DR TestingLog' from bidirection to single direction.

 

Regards,

Jimmy Tao

Dayna's avatar
Dayna
Helper V
7 years ago

Hi Jimmy,

 

Tried it - but still unable to make the relationship active. I've included a screenshot of the updated ERD:

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    7 years ago

    Hi Dayna,

     

    Sorry for late, I have reproduced your issue like below. For example, if you create a slicer based on one column in MasterCalendar table and select a value to filter DR TestingLog. There're two kinds of filter route, one is MasterCalendar-> DR TestingLog, another is MasterCalendar-> DR Server-> DR TestingLog. So there may be two different filter results in DR TestingLog which may cause ambiguity. 

      

     

    Regards,

    Jimmy Tao

     

    • Dayna's avatar
      Dayna
      Helper V
      7 years ago

      Hi Jimmy,

       

      That makes sense, and thank you for your help. It's much appreciated!

       

      All the best,

      Dayna