Forum Discussion
Many relationship on dimensionto be activate
Hi,
I have an issue.
I have a fact table which contains two persons: The holder of a contract and eventually his/her partner.
They are both linked to a person table dimension...
When I link both to my dimension table with power pivot I can't activate both relationship:
How can I manage that? Do I need to make two versions of the dimension table?
Thanks for answers.
1 Reply
- amitchandak
Super User
Anonymous , seem like bi-directional relation or over-model creating loops of two paths and the relationship is inactive. check the model and try to resolve that
if you have a valid inactive then we can use userelationship
