Forum Discussion

moorejr7's avatar
moorejr7
New Member
7 years ago
Solved

Filtering multiple dimensions by a single "parent" dimension

Hello,

 

I'm trying to create a model where I have one parent dimension that is filtering down two other dimensions. The model is supposed to be following a snowflake schema. The two child dimensions then need to be connected to facts. However, I cannot create all of the relationships that I need to due to "ambiguity between tables". Here is the model I have created:

 

 

As you can see, the two relationships from Child Dimension 2 that are connecting to Fact 1 & 2 are inactive. This is where my problem is. When trying to activate either of those relationships, I receive the following error message:

Any help or tips at all would be greatly appreciated!