Forum Discussion
matthewcornish5
3 years agoFrequent Visitor
Modelling with repeating dimensions
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
1 Reply
- CNENFRNLCommunity Champion
Unpivot all those columns containing users when importing the dataset into data model; then a single dimension table of user is enough.