Fact is on top and then relation ship on bottom be help of Left Join like below.
Here, Data model looks only one single dimension table which directory called Location_Zip. Many to one relationship like below.
Load * FROM Path;
Load * FROM Path1;
Load * FROM Path2;
Load * FROM Path3;
1) If you want to do in Qlik go and merge. I am not aware of DW
2) You can use by split like below. We can do anything with Qlik as technical prospective and may be work around atleast. If you provide more information we may help better
Load Field1, Field2, 'amount of tax' as Flag from HeaderTable;
Load Field1, Field2, 'rows related' as Flag from DetailTable;
I wrote the sql query for this for more clarification:
,b.[Freight]* ([UnitPrice]*[Quantity]/(select sum([UnitPrice]*[Quantity]) from [[order details] as c where c.orderid=b.orderid) ) as freight_of_detail
FROM [Order Details] as A
inner join [orders] as b on (a.orderid=b.orderid)