SNOWFLAKING

[tim_goodsell]

Hi

I have a scenario where I am trying to report on how many insurance claims a company employee is managing at the end of each month

An employee can be assigned to one or more positions, there will be a start and end date for each employee

A position can be assigned to one section also a position can move between sections

A i see it I have three dimensions Section , Position and Employee , but I 'm not sure how to link them without snowflaking

Regards

Tim

[BoxesAndLines]

Wouldn't that be your fact table?

[tim_goodsell]

Thanks .. i presume you mean having a fact table with the following fields

SectionKey
PosiitionKey
UserKey
StartDateKey
EndDateKey

Regards

Tim

[BoxesAndLines]

Yes sir.

[tim_goodsell]

Thanks

[Sponsored content]