Hyperion Planning (MOSC)

MOSC Banner

Convert Design Time Prompt "Members" Strings to MDX Format

edited Nov 12, 2018 2:53PM in Hyperion Planning (MOSC) 3 commentsAnswered ✓

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center