SNOWFLAKING

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

Wouldn't that be your fact table?

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

SectionKey
PosiitionKey
UserKey
StartDateKey
EndDateKey

Regards

Tim

Yes sir.

Thanks