Forum Discussion

jPinhao's avatar
jPinhao
Icon for Advocate II rankAdvocate II
10 years ago

Dimensional Modelling advice

Hi, I've been trying to solve an issue, and to date I haven't been able to reach what I'd say is an optimal solution. I have a dimension (Features) which needs to be referenced in 2 other dimensions...
Need Help
v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

jPinhao

 

In this scenario, if you only care about the Features either Used (realted to Action dimension) or Owned (related to Session dimension), your schema is fine. But if you need to know the count of Features sliced by both Action dimension and Session Dimension, you'd better build a fact table comtains Action, Session, Feature information between Dim_Action and Dim_Session connecting Dim_Feature.

 

Regards,