select Dim1.Col1, Dim2.Col1, Dim3.Col1, Dim4.Col1, Fact_Table.Quantity
from
Fact_Table F
left join Dim1 A ON A.KeyDim1 =  F.FDim1
left join Dim2 B ON A.KeyDim2 =  F.FDim2
left join Dim3 C ON A.KeyDim3 =  F.FDim3
left join Dim4 D ON A.KeyDim4 =  F.FDim4