I am trying to generate a new Calculated Member that contains the value
for the 'Current Financial Year' using the following code:

iif(
IsAncestor([FinPeriod].CurrentMember,strtomember("[FinPeriod].[Year].&["
+ CStr(Year(Now())) + "]").FirstChild),
(strtomember("[VectorFinPeriod].[Year].&[" + CStr(Year(Now())) +
"]"),[Dynamic Dates].[All Dates]),
iif(
IsAncestor(strtomember("[FinPeriod].[Year].&[" + CStr(Year(Now())) +
"]"), [FinPeriod].CurrentMember),
[Dynamic Dates].[All Dates],
null
))

This worked fine until April 1st roled by and now my financial year
still related to the previous one.

My FinPeriod dimension starts on the 1st April.

What I need is to be able to take into account that Apr - Dec of any
given year is actually the current year +1 to give me the financial
year. But that Jan, Feb and March are simply the current year derived
from the NOW function.

Does anyone have any idea on how to go about this? It's driving me
mad.

Thanks

why you don't use a property in your finperiod dimension ?

a property like "Current FYear" (which is 0 or 1), and then, simply filter
your dimension to take the members with his property set to 1.

<chrisb (AT) targit (DOT) co.nz> wrote