Modelling with repeating dimensions

[matthewcornish5]

Hi All

I'm after some advise around modelling.

I have a list of projects and would like to know the best way of modeling them when the user and date dimensions are refrenced repeatedly.

I need to be able to see who was on each portion of a project along with their attributes from the users dimension.

I can see a few options:

A) repeat the dimension for each column. Clutters the model and makes reporting on 1 user across all columns messy

B) inactive relationships. Cleaner but now the measures are messy

Any guidance would be appreciated, example table below

[CNENFRNL]

Unpivot all those columns containing users when importing the dataset into data model; then a single dimension table of user is enough.