I need to create a time dimension based on the 4-5-4 fiscal calendar structure. I'm using VS 2008.
The start of the fiscal Year needs to be December 28, 2008 which is a Sunday. Sunday is the first day of the week. I have been successful in creating the date level of the dimension. What I also need os to have the Quarters, Months, Weeks to reflect the fiscal calendar. I used the dimension wizard to setup the time dimension in the data source.
I am open to any good ideas.
Thanks