Forum Discussion
Help with shared dimension between two fact tables
Hi. I have tried looking for an answer but haven't found one. Let's say I have 2 fact tables: Customers and Sales. Both of these share a common dimension called SalesPersons. But, it may not b...
Greg_Deckler
Community Champion
Community ChampionWhat error or problem are you seeing connecting the common dimension table to your 2 fact tables? Your work-a-round is fairly common but interested in the issue you are seeing.
The relationship on the 2nd fact table remains Inactive, when I try to active it says: "You can't create a direct active relationship between Sales and SalesPersons because an active set of indirect relationships already exists between these tables. To make this relationship active, set the Cross filter direction to 'single', delete or deactivate any of the indirect relationships first."