Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Relationship between two fact tables

Hi,

 

is that an appropiate way to build a relationship between those two fact tables?

 

 

Basically this is a 1:n relationship between those facts. I tried to create a dimension for that order_id which is on the left side the unique identifier for the OrderHeader information and on the other side a real dimension for OrderDetails. Now I can use this artificially created dimension (dim_order) to filter both facts.

 

But i guess this is not best practise

 

Cheers

 

 

 

Need Help
Show and Tell
Tips and Tricks

2 Replies

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

    Anonymous , Edit relation and change 1-1 relation between Dim_order to fact_orderHeader as 1 to Many

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      amitchandak  This does not help. Did you read my whole question? 

      I cannot change that because it is 1:1 as you can see in the picture 😁