0 Replies Latest reply: Jan 17, 2013 10:12 AM by User458365 RSS

    Best Practice - Outer Join between Fact and Dim table

    User458365
      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?

      Thanks