If you have 3 facts and 4 dimension and you need to join would you recommend joining fact with fact? If no than what is the option? Why you won’t join fact to fact? | OBIEE

In the BMM layer, create one logical table (fact) and add the 3 fact table as logical table source.