Skip to Content
0
Dec 02, 2010 at 08:18 PM

Script logic - Capture property for member in scope

51 Views

Hello,

In script logic, how do you capture a value stored in a property for a member currently in scope?

Background: I am developing allocation functionality for a client that wants to input into a "summary" customer and have the new number allocated down to its base descendants. I have created dummy customers that represent the summaries, e.g. for CUST1 I have created CUST1.INP.

When the user sends data, CUST1.INP will be in scope, and I need to capture its equivalent summary (CUST1) to allocate to it. In lieu of any method of simply removing the .INP (which I don't think is possible?), I have created a property that will store the summary. I am trying to get the script logic to capture the value of that property.

I have tried various *SELECT and *MEMBERSET functions but can't find anything that will work. For example:

*SELECT(%CUST_MBR%,"CUSTMAP","CUST","ID in %CUST_SET%")

or

*MEMBERSET(%CUST_MBR%,"[CUST].CurrentMember.Properties("CUSTMAP")")

etc.

Thanks,

Steve