Snapshots and Date Dimensions

If you build weekly, monthly, quarterly, yearly, snapshot fact tables, do you also build weekly, monthly, quarterly, yearly, dimensions as well or do you use the daily date dimension and associate to the first/last day of the week, month, quarter, year?

Hi,

I have used first/last day of the week, month, quarter, year in the dimension daily date dimension and it worked well for the reporting puropse.

thanks

We also use last day (i.e. snapshot date) of the week, month etc without any problem.

Same here, 1 dimension.  I will usually add additional natural keys for specific periods (month NK, quarter NK, etc...) and populate them on the appropriate rows, leaving it null (or blank) on rows that do not apply.  This stabilizes the code should the business decide to use different points in time to identify each.  For example, going in they may decide to use the first day of the month, then later on decide to use the last day of the month.  Such a change would only require updating the NK column in the table, rather than changing code to locate the appropriate row.