Relationship between two fact tables

[Anonymous]

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

[amitchandak]

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

[Anonymous]

@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 😁