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.

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.