Forum Discussion

sshweky's avatar
sshweky
Helper III
10 years ago
Solved

Relationship issue

Hi Everyone - I've been on trial and error for 3 days & I cannot fix this! Here's the situation:   I have 2 divisions in my company and I am trying to track sales, inventory, on order, in productio...
Need Help
  • Kieran's avatar
    Kieran
    10 years ago

    Hi,

    I may be able to help, but I can't read the text in your model. Can you resend so I can read it please and I will try and help you.

     

    Kind Regards,

     

    Kieran.

Kieran's avatar
Kieran
Advocate II
10 years ago

Hi,

I may be able to help, but I can't read the text in your model. Can you resend so I can read it please and I will try and help you.

 

Kind Regards,

 

Kieran.

sshweky's avatar
sshweky
Helper III
10 years ago

I think I figured it out. Thanks!

  • rich_solomon's avatar
    rich_solomon
    New Member
    10 years ago

    So what was the issue, and how did you solve it?

    • sshweky's avatar
      sshweky
      Helper III
      10 years ago
      I was creating 2 way relationships with everything which I didn't understand. When I switched to single, everything started working
      • kcantor's avatar
        kcantor
        Community Champion
        10 years ago

        Quick tip: Put your lookup tables at the top, your bridge tables in the middle, and the fact tables at the bottom. This will help you visualize how filters flow downhill and allow you a better view to organize your relationships. I also make my lookup tables (or bridge tables) smaller so that I know at a glance which type of table it is. I only offer this advice because that is a massive model.