0 Replies Latest reply on Jan 17, 2013 4:12 PM by User458365

    Best Practice - Outer Join between Fact and Dim table

      Hi Gurus,

      Need some advice on the below scenario

      I have an OOTB subject area and we have around 50-60 reports based on it. The related subject area Fact and Dim1 table are having inner join.

      Now I have a scenario for one report where outer join has to be implemented between Fact and Dim1. Here I am against changing the OOTB subject area join as the outer join will impact the performance of other 50-60 reports.

      Can anyone provide any inputs on what is the best way to handle this scenario?