So you set all the metrics to outer join in the report data options, however your only able to get it to do a left outer join. Recently, I ran into such a situation and realized I wasn’t clear on why the sql engine does left outer joins in some cases and full outer joins in other. After some digging around and testing it seems that (rightly so) full outer joins are only applied to intermediate tables with the same join keys. Read more…

SQL Engine full outer join, sql join, vldb settings