Forum Discussion

moesteez's avatar
moesteez
Helper I
6 years ago
Solved

Joining two different database systems

Hi guys,   I have two databases that Ive linked up and reporting on. One is a point of sale system and the other is an accounting system (xero). Both systems have multiple, but identical, stores. ...
Need Help
  • Mariusz's avatar
    Mariusz
    6 years ago

    Hi moesteez 

     

    Try to avoid Bidirectional relationships as they create a lot of problems with data, review all your relationships ( switch from Both to Single direction where possible ) this should remove ambiguity.

    Create a Store dimension ( if you haven't yet ) and create relationships ( one to many ) with all the fact tables.

    Use dimensions ( like calendar and store ) to propagate the filter.

     

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    Mariusz Repczynski

     

     

Mariusz's avatar
Mariusz
Community Champion
6 years ago

Hi moesteez 

 

Try to avoid Bidirectional relationships as they create a lot of problems with data, review all your relationships ( switch from Both to Single direction where possible ) this should remove ambiguity.

Create a Store dimension ( if you haven't yet ) and create relationships ( one to many ) with all the fact tables.

Use dimensions ( like calendar and store ) to propagate the filter.

 

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
Mariusz Repczynski

 

 

  • moesteez's avatar
    moesteez
    Helper I
    6 years ago

    Thanks Mariusz 

     

    That was the problem. Works great now!