Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Cannot create active relationship - Have to create another table?

Hi there,   Got a issue that is: an active relationship cannot be created, please refer to following screen capture.   Following active relationships have been created: from Domains[Domain] to Q...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , domain has two paths to reach QueryByPage_Bydate. You have to choose only. If Queries_Properties and Queries_byPage are fact, they should not join.

     

    Or merge , these two Queries_Properties and Queries_byPage and use that in place of ,Queries_byPage so that it has all info it needed from  Queries_Properties

     

    In the end of this video I explained about such a case - https://youtu.be/kXls79iNPqc?list=PLPaNVDMhUXGb16ivjoDbhjX54b8TGRjOF&t=1271

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , domain has two paths to reach QueryByPage_Bydate. You have to choose only. If Queries_Properties and Queries_byPage are fact, they should not join.

 

Or merge , these two Queries_Properties and Queries_byPage and use that in place of ,Queries_byPage so that it has all info it needed from  Queries_Properties

 

In the end of this video I explained about such a case - https://youtu.be/kXls79iNPqc?list=PLPaNVDMhUXGb16ivjoDbhjX54b8TGRjOF&t=1271