This technique allow you to :
It's also known as :
You implement it by creating in the Business Model Layer:
When minimum one measure of each logical fact table are included in the query, the BI Server generates two queries for each logical table source and perform a full outer join between them by the dimension columns.
The physical sql issued depends of some database parameters: OBIEE - How to control the use of the WITH CLAUSE and of STITCH Join ?