Hi,

I want to rename the display of the Fiscal Year, for
eg. "Apr 1st 2001 to Mar 31st 2002" should read "FY 2001"
and not "FY 2002". Can anyone advise me how to do.

In the Fiscal Period dimension, the formula in dimension
editor is

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 )

Can anyone advise me how to do.

Thank you.