Recently had been posed with a issue from an RPD developer where Outer Joins had been replace with Inner Joins when using two Unconformed Dimensions. So off to Oracle Support site to find any Bug/Doc on such; no luck so I open a SR and Oracle responded with the following doc: Setting Fact to Total Level Of Hierarchy No Longer Forces Outer Join (Doc ID 1601703.1). I have tested the fix in this doc and it does fix the issue we were experiencing. There is two approaches int he doc one for RPD level (environment wide) and one for reports only.
It involves setting a session variable FOJ_GRAND_TOTAL_LBM=1.
