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.