Forum Discussion
Dimension Table when same information exists in multiple columns
Hi -
If I understand you correctly, you will need to have two staff "dimension" tables. The reason is that only one relationship can be active at a time from the dimension table:
Note the dotted line for one of the relationships - this means it exists, but is not active, you can only have one active relationship at a time.
By creating two dimensions, you can have one active relationship for each field in your fact:
Hope this helps -
Peter
Hi -
If I understand you correctly, you will need to have two staff "dimension" tables. The reason is that only one relationship can be active at a time from the dimension table:
Note the dotted line for one of the relationships - this means it exists, but is not active, you can only have one active relationship at a time.
By creating two dimensions, you can have one active relationship for each field in your fact:
Hope this helps -
Peter
Hi Peter
That makes sense, and would solve the problem. I can now move forward with the build!
Thank you!
