5 Replies Latest reply on Aug 30, 2017 11:45 AM by user652652

    How to impliment this in OBIEE-Change OBIEE generated query


      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.