So I made joins according to that in Physical and Logical Layers and I kept F2 at Total level for D2,D3.
So far it is working fine with measures and dimesions(F1,F2,D1,D2,D3). But My problem is I have an attribute in F1. As soon as I brought that F1 attribute with F1 ,F2,D1,D2,D3..THE F2 measure is becoming null.
I know one solution I can make alias of F1 and make self join with F1 and bring that attribute...But that will create extra join which I don't want that...Is there any alternative solution ?