Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Need help on a dimensional model scenario

2 posters

Go down

Need help on a dimensional model scenario Empty Need help on a dimensional model scenario

Post  neo.helios Wed Oct 10, 2012 9:17 am

Need suggestions to model the scenario explained below

I have a dimension "EXPERIMENT_DIM" which has a hierarchy Conceptual Phase -> Master Phase -> Implementation Phase. At each phase, I need to link a set of users responsible for running the phase and with a flag for one of them as primary user. The user data is available in "USER_DIM"

Do I need a bridge table between EXPERIMENT_DIM and USER_DIM to handle this scenario? Please suggest

Thanks in advance

neo.helios

Posts : 11
Join date : 2010-11-02

Back to top Go down

Need help on a dimensional model scenario Empty Need help on a dimensional model scenario

Post  RM7 Wed Oct 10, 2012 11:55 am

The bridge table should be between User dim and the fact.

RM7

Posts : 3
Join date : 2012-10-10

Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum