Hello:

I have a Date Dimension in a MS SQL Server 2005 data warehouse. It is populated with one row per day and it is used in my data marts that require dates for analysis ie. posting date, invoice date, etc.

My question: I have a new data mart within the warehouse that requires a monthly date so I can report on monthly numbers. If my dates in the date dimension are daily, which date do I use to represent the month? The last date of the month or do I create a new dimension for months. My reference text says I do not create a new dimension for months, so I am not sure what to do.

Any help would be appreciated. Thanks.