Previously, I blogged about Server time dimensions. This is where a time dimension table is generated automatically on the Analysis Server instead of having to be created manually in the Data ...

A nice new feature in SQL Server 2008 is that you can have the New Dimension Wizard actually generate and populate a Time dimension table in your Data Warehouse (assuming you have the privilege).