Forum Discussion

Mike_Mace's avatar
Mike_Mace
Icon for Resolver I rankResolver I
6 years ago
Solved

Active / Inactive relationships

I use "Date" and "Company" in standalone tables in order to create relationships with variables (planned and actual). On one report the relationships work fine for both Date and Company.   On a sec...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    OK, look at your picture and follow your arrows

     

    Path 1: Date Calendar -> MEP Planned -> Company -> MEP Actual

    Path 2: Date Calendar -> MEP Actual

     

    2 paths, both cannot be active. I don't know how to explain this any differently. 

     

    For that matter, you also have 2 paths from Date Calendar to Company and Date Calendar to MEP Planned so you basically just have a big circle and that is generally not a good data model.

Mike_Mace's avatar
Mike_Mace
Icon for Resolver I rankResolver I
6 years ago

Hi Greg_Deckler ,

 

The second arrow led to another independent variable. It's not affecting MEP Actual table. 

 

Reattaching with the relationships to the other viariables deleted.

 

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

OK, look at your picture and follow your arrows

 

Path 1: Date Calendar -> MEP Planned -> Company -> MEP Actual

Path 2: Date Calendar -> MEP Actual

 

2 paths, both cannot be active. I don't know how to explain this any differently. 

 

For that matter, you also have 2 paths from Date Calendar to Company and Date Calendar to MEP Planned so you basically just have a big circle and that is generally not a good data model.