If We Have 3 Facts And 4 Dimension And We Need To Join Would You Reco

1.	If We Have 3 Facts And 4 Dimension And We Need To Join Would You Recommend Joining Fact With Fact? If No Than What Is The Option?
Answer» In the BMM LAYER,we can create one LOGICAL table (fact) and ADD the 3 fact table as logical table source. In the BMM layer,we can create one logical table (fact) and add the 3 fact table as logical table source.

If We Have 3 Facts And 4 Dimension And We Need To Join Would You Recommend Joining Fact With Fact? If No Than What Is The Option?

Answer»

In the BMM LAYER,we can create one LOGICAL table (fact) and ADD the 3 fact table as logical table source.

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