Resolve ambiguous relationships

Ambiguous relationships occur when the data represented by a table or dimension can be viewed in more than one context or role, or can be joined in more than one way.

The most common ambiguous relationships are role-playing dimensions, loop joins, and reflexive and recursive relationships. For details about these types of relationships, see the subsections in this topic.