SQL server ActivityMonth to fiscal year and Fiscalperiod

Hi All,

I am working on BI 7.0. we are getting data from Sql server Activitymonth( data type Int4 , length 4, external length 11) yyyyMM format. I need to map this to fiscalyear, fiscalperiod, fiscal year variant.I took variant as constatnt.I unable to get the correct format for year and fiscal period.Can any one help on this? If routines solves this issue,please send me the code.

Thanks in advance

kavi