Spreadsheets are often under appreciated by programmers.
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^.
© 2003-2011 Pradeep Gowda