Date dimension + holiday information

[Firecat1970]

Dear expert buddies,

I would like to know if a date is a working day, so I will add an attribute to the Date dimension. That's fine.

How would you handle multiple countries holiday? e.g. April 11 is working day for country A, but a holiday for country B, and I need to count working day in some of my queries.

Would you have 1 country 1 day 1 record in Date Dimension? or there are some nicer method?

Thank you very much.

 

[vascan]

You have to add a column Holiday Flag.For multiple countries,add country_id as a foreign key to the time dimension table.
So,your time dimension would be something like-
Date_id Holiday_flag
03/25/2005 N
03/26/2005 Y
03/27/2005 Y
03/28/2005 N

There is no conventional source for this.You have to spend a day or two and build a spreadsheet and then load this data in the table.

 

[MDXer]

I would create it as a snowflake with the date as the joined column.

Table 1 has all of your dtaes and date related information the second table would have Dates and holiday name along with any other holiday related info such as country or religion. This will suit your current needs while at the same time offer greater detail.

Shoot Me! Shoot Me NOW!!!
- Daffy Duck