Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Convert to MDX

Hi,

I have tried all kinds of iterations to convert this BSO calc to MDX. Any ideas/help? The Subvar &Prior_Year_1 is set to 'FY23'. I need it to return numeric value of '23'.


CalcMgrDoubleFromString(@substring(@name(&Prior_Year_1), 2))

This works: ((STRTONUM(SUBSTRING("FY23", 3, 4))))

However, substituting &Prior_Year_1 like: ((STRTONUM(SUBSTRING([&Prior_Year_1 ], 3, 4))))

Throws an error: Syntax error in input MDX query on line 10 at token ','

Also, can get it working on a Attribute, but in this instance Attribute will not work. Attribute method like this works:

(STRTONUM(SUBSTRING([Sites].CurrentMember.Vintage, 4, 6)) - 1)

Thanks. Appreciate any guidance.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!