Introducing a third dimension based on two unrelated dimension tables?

Hi amitchandak,

Thanks - but I didn't quite understand.

Could you please guide me to the concept of how this could work for me?

Let me try to explain my scenario a bit more:

• We are two different groups with 10-20 legal companies in each, merged to one
• We have a groupwide main dimension to split business into several areas, and because of different legacy systems, this determination is a bit different for each group
• This dimension could be determined based on the country of sales (some areas are country specific, others are clusters, and you would also have a "the rest") and the customer group from customer master data, and the product group, a sub category, and a brand owner from the product master data
• Some transformations and additional information is needed to get this "mapping" in place
• We currently have this model running, but the performance is so-so, and I want to lean this process, and I was hoping that we could get this dimension away from the fact table because of obvious reasons.

What I was hoping to go for, was a third table where we have the mapping cleared out based on the "key" you can create in the customer master data and the "key" from product master data. But I struggle with trying to connect the dots from the customer and product master data, to this third dimension.

I end up with the "only one filtering path between tables is allowed".

This is from my last attempt, where I first thought to create a many-to-one relationship from the customer and product tables using a bridge, then likewise for the "business area determination" table. I understand this relationship is troublesome for Sales Data - but I was just trying.

The error pops up once I try to set Customer Bridge - Business Area Bridge relation direction to Both.

Do you mean there's some trick to work around this?