Hi,

In Microsoft Analysis Manager, the fiscal year setting for
is different from some companies. E.g from Apr 03 to Mar
04, in Microsoft Analysis Manager, it will capture as FY
2004. However, in my company, it is considered FY 2003.
Can someone tell me how I could reset the fiscal year
setting by myself.

The default setting for the Member Key Column of the
fiscal year property is as follows :

DatePart(year,Case when (DatePart
(month, "dbo"."TIME"."Period") < 4 or (DatePart
(month, "dbo"."TIME"."Period") = 4 and DatePart
(day, "dbo"."TIME"."Period") < 1))
then "dbo"."TIME"."Period" Else DateAdd(year,
1, "dbo"."TIME"."Period") End )

Thank you very much.