Creating a Custom Time Dimension based on Fiscal Calendar

[adam_mc]

I need to create a time dimension based on our Fiscal Calendar.

Our Fiscal Year begins in February, and looks like as follows:

• Fiscal Month 1 (February) - 4 Weeks
• Fiscal Month 2 - 4 Weeks
• Fiscal Month 3 - 5 Weeks
• Fiscal Month 4 - 4 Weeks
• Fiscal Month 5 - 4 Weeks
• Fiscal Month 6 - 5 Weeks
• Fiscal Month 7 - 4 Weeks
• Fiscal Month 8 - 4 Weeks
• Fiscal Month 9 - 5 Weeks
• Fiscal Month 10 - 4 Weeks
• Fiscal Month 11 - 5 Weeks
• Fiscal Month 12 (January) - 4 Weeks

Note: Quarters 1 - 3 are 4/4/5 and Quarter 4 is 4/5/4.

We also have a 53 Week every 5/6 Years; Last 2012, Next 2017.
Whenever there is a 53 Week, that year is considered "shifted" and we do Year over Year as follows:

• TY Fiscal Year Week = 201411
• LY Fiscal Year Week = 201311
• LLY Fiscal Year Week = 201212

Any thoughts/suggestions would be greatly appreciated.
Thanks in advance,
Adam.