We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
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

PCMCS Custom Calculation error: MDX Member functions cannot be used in the argument

Received Response
26
Views
4
Comments
edited Jul 8, 2020 9:34PM in Profitability and Cost Management 4 comments

Summary

Using substring and concat MDX functions in PCMCS custom calculation is not working

Content

Hi,

I am trying to get the data from members using string manipulation functions in MDX , i.e., concat and substring in a custom calculation required in PCMCS. I have the following syntax but I am getting validation error.

MDX query below:

[Adjustment In] := 
(StrToMbr(Concat("AF_",[Entity].CurrentMember.MEMBER_NAME)),[Account1],[Calculation Rules],[Net Balance]);

Validation error: MDX Member functions cannot be used in the argument [Script]

This is not working although I found another post with same solution and looks like it worked. Please help. Is MDX function not valid to be used in tuple?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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