Once of the more common issues with working with data in a cube is that it does not always line up like we expect. This is usually a combination of our interpretation of how SSAS will handle our business and a lack of understanding of some feature, option, property or toggle switch we forgot to flip. None of these occurs more often than in working with a set of dimensions that intersect multiple fact tables or measure groups, but not both. This can cause some strange behavior along the dimensionalities that don’t intersect.

The property IgnoreUnrelatedDimensions is set at the measure group level and allows the developer to control the way this will be handled. IT has two options