How to create a time dimension in SQL Server 2005

Written by Thomas Ivarsson on 02 October 2007. Posted in Time Dimension

How to create a time dimension in SQL Server 2005.

A lot of posts in the SSAS2005 newsgroup have questions regarding how to construct a time dimension.

In SSAS2005 you can generate a server time dimension but having control over this is much better and it is not that hard.

Let’s start with creating a list of dates. Jamie Thomson (http://blogs.conchango.com/jamiethomson/rss.aspx) has a TSQL solution with a new feature in SQL Server 2005 called common table expressions or CTE: s

Start management studio and the database engine. Start a new query and copy this statement:

How to create a time dimension in SQL Server 2005

Similar Articles