Can someone please help me on this issue? I am not sure if it is the way OBIEE will behave and try to do inner join rather than doing the Outer join. Thanks, Suhel

It is very simple model. Though in physical, I am doing snow-flaking using different alias of the dimension. I have attached the screenshot of Physical and BMM for your reference. In the physical layer, the dimension (XW_GL_SEGMENT_DH) is connected to fact through W_GL_ACCOUNT_D. There is another way to the fact through…