As mentioned in the introduction of the previous recipe, Finding related members in the same dimension, this recipe deals with a slightly different scenario. It explains how to find the related members using two or more dimensions.
Before we start, let's get one thing straight - when we say a dimension, we mean any hierarchy in that dimension from now on.
Dimensions, unlike hierarchies of the same dimension, are independent objects. Without a third table in form of the fact table, they are unrelated, at least in the dimensional modeling sense. When a fact table is inserted among them, the many-to-many relation comes into existence.
In other words, there are two different types of combination we can make ...