Forum Discussion

matthewcornish5's avatar
matthewcornish5
Frequent Visitor
3 years ago

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

  • CNENFRNL's avatar
    CNENFRNL
    Community Champion

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