Hi Experts,
We have Dimensions D1 and D2. Fact F1.
D1 and D2 are joined to F1 and confirmed dimensions.
1. D1 to F1 left outer join
2.D2 to F1 is inner join.
When we apply any filter on D2 then the left outer data(i.e. all data from D1) is not appearing in report.Because where clause apply at end of query. How to design if we want
1. First where clause for D2 apply and then
2.Left outer join apply,so that we can get all data from D1.
