Is Holidays a dimension?

View previous topic View next topic Go down

Is Holidays a dimension?

Post  gbaren on Thu Apr 03, 2014 3:01 pm

On the one hand, I can put US_Holiday_Flag, CA_Holiday_Flag, MX_Holiday_Flag, etc. into the Date dimension. On the other hand, I may not know 10 years into the future what all the holidays might be in all the countries I need to support. I've seen ready-made table scripts with the former. Is there standard school on this? Or, at least, a healthy debate?

gbaren

Posts : 15
Join date : 2014-01-30
Location : 02

View user profile http://equalsql.wordpress.com

Back to top Go down

Is Holidays a dimension?

Post  zoom on Thu Apr 03, 2014 5:23 pm

Yes it is, but it can be a outrigger dim to the date dim since you want to support multiple holidays.

zoom

Posts : 97
Join date : 2010-08-23
Location : Chicago

View user profile

Back to top Go down

Re: Is Holidays a dimension?

Post  Mike Honey on Tue Apr 08, 2014 8:21 pm

This can be a real "banana skin" area. Watch out for countries like Australia where each state has it's own public holiday dates and NZ with County holidays.

The other tricky aspect to consider in your design is "who's holiday" e.g. you have a customer in location X serviced by a team in location Y - which public holidays should apply?

Good luck!
avatar
Mike Honey

Posts : 185
Join date : 2010-08-04
Location : Melbourne, Australia

View user profile http://www.mangasolutions.com

Back to top Go down

Re: Is Holidays a dimension?

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

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