The first thing you have to do is figure out what month is the start of your year.
In your load script you need to establish some reference to the beginning month so let's say your fiscal year begins in July
set a variable to the beginning month number.
let vYearBeginMonth = 7;
then load your periods, the monthstart function has an offset parameter that allows you to change the begin date that will be returned so as long as we know when the year starts then you can adjust the periods to reflect the right date.
Year, Period, Monthstart(MakeDate(Year,Period,1),($(vYearBeginMonth) - 12) - 1) as PeriodStartDate
Fiscal Period Mapping.qvf 176.0 K