Hi All,

I red in a site that Web Focus 8.0.0.3 allows multi fact join.

I Have Fact_Budget and Fact_Actuals tables which is joined by common dimension Date,Country, Product.

When I do Modeling like this the value doubles.

Fact_Budget--->Date--->Fact_Actuals
Fact_Budget--->Country--->Fact_Actuals
Fact_Budget--->Product--->Fact_Actuals

Kindly let me know how do i do this modeling.

Thanks

Hari

To the best of my knowledge, multi-facts are managed through the meta-data, not an actual JOIN. Built a multi-parent cluster and try again.