SNOWFLAKING

View previous topic View next topic Go down

SNOWFLAKING

Post  tim_goodsell on Thu Oct 21, 2010 2:05 am

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

tim_goodsell

Posts : 49
Join date : 2010-09-21

View user profile

Back to top Go down

Re: SNOWFLAKING

Post  BoxesAndLines on Thu Oct 21, 2010 9:31 am

Wouldn't that be your fact table?
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

View user profile

Back to top Go down

SNOWFLAKING

Post  tim_goodsell on Thu Oct 21, 2010 9:14 pm

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

SectionKey
PosiitionKey
UserKey
StartDateKey
EndDateKey

Regards

Tim

tim_goodsell

Posts : 49
Join date : 2010-09-21

View user profile

Back to top Go down

Re: SNOWFLAKING

Post  BoxesAndLines on Thu Oct 21, 2010 10:33 pm

Yes sir.
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

View user profile

Back to top Go down

Re: SNOWFLAKING

Post  tim_goodsell on Thu Oct 21, 2010 10:44 pm

Thanks

tim_goodsell

Posts : 49
Join date : 2010-09-21

View user profile

Back to top Go down

Re: SNOWFLAKING

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top


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