Data Warehouse Time Dimension Generator Using Spreadsheets

Thursday, 19 March 2009

Spreadsheets are often under appreciated by programmers.

But, spreadsheets are in generating and manipulating tabular data. Case in point -- Time dimension generation . One more example

I had written a python script to this, but while trying to generate unique week,month IDs I felt that I had been coding too much for a one-off script. Thats when I dusted my primitive knowledge of spreadsheet functions and came up with this:

Note The download links are fixed. You should be able download the generator spreadsheets.

Spreadsheets are appropriate solution in the BI practice because typically the dimension information is given by business users, most of who are Excel Jockeys ^TM^.