PCMCS Custom Calculation error: MDX Member functions cannot be used in the argument
SummaryUsing substring and concat MDX functions in PCMCS custom calculation is not working
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?