engstevo (7/3/2013)
the script that will enable you to create the new values for each of the measures
What do you mean by that?
There are build in T-SQL datetime function to determine calendar quarter, month, week and day of the week. Determining financial calendar parts will depend on the set rules used by the company - they are no universal. There is no such thing as standard Financial Year. They do really depend on country you are in and a company. There are many different types of Financial Years based on 4-4-5 weeks.
Check this out: http://en.wikipedia.org/wiki/4%E2%80%934%E2%80%935_calendar
P.S. Are you sure that if you pass this test with all help you will be able successfully perform tasks required by the postition you are trying to fill?