Convert Design Time Prompt "Members" Strings to MDX Format
Is there a way to convert a Members DTP Array to MDX format to pass to the @CalcMgrMDXDataCopy function? The members are passed with the standard essbase quotes: (i.e. {"Member1","Member2"}), but I need them to be converted to MDX format (i.e. {[Member1],[Member2]}). I've tried using the @REPLACEALL function on the DTP variable, but it doesn't seem to work at all. Any ideas would be appreciated.