Requirement

Let’s imagine there are fact tables F1.F2,F3.F4 and dimension tables D1,D2,D3,D4,D5. A measure in the F1 is set as the implicit fact
column.
The fact tables F1..F4 share the dimensions D1..D3.
The dimensions D4 and D5 are only shared by the fact tables F2
 and F3.
We experienced a problem making a query F2-D1-D2-D3-D4-D5:
OBI tried to go to the fact table F4 and gave an error
saying the F4 is not connected to the dimensions D4 and D5. Of course it’s not, but why OBI went to the F4 in the first
place?

would be appreciate if we come across with better solution and post the same here.

Thanks all,