TM1 Forum

I need to retrieve the current year from a cube and increment and convert back to a string to be able to use StrToMember. What is the opposite function to strToValue that will allow me to do this? I've tried FORMAT, CStr, Str as advised by the LLMs but nothing works. I cannot believe this is not possible.

Why not doing this in the system cube itself in a different parameter ? As a string

I agree. Much easier done in the lookup cube itself. Then simply call the "next year" value from the cube in the MDX.