Forum Discussion

heidibb's avatar
heidibb
Icon for Helper IV rankHelper IV
6 years ago
Solved

Relationship Issues

Hello,  I have this data model pictured below. My issue is trying to figure out why my relationship between Academic Program and Graduation Retention can't be active.   Graduation Retention has a ...
Need Help
  • parry2k's avatar
    parry2k
    6 years ago

    heidibb  is It is ok to have an inactive relationship, you can have only one active relationship between tables, to use inactive relationship, use userelationship function in your measure expression

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

heidibb because it is will create a circular relationship, if you follow the errors, this graduation table can filter thru another path from the academic table,

heidibb's avatar
heidibb
Icon for Helper IV rankHelper IV
6 years ago

while i understand the circular relationship, I'm not sure what other path I can use to filter both connections (Success and Graduation Retention) if it's not joined to both.

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    6 years ago

    heidibb  is It is ok to have an inactive relationship, you can have only one active relationship between tables, to use inactive relationship, use userelationship function in your measure expression