Skip to Content
avatar image
Former Member

Pass Data Manager ComboBox Variable to Script Logic?

Hello Experts,

I have used "combobox" option  in prompt of Data Manager Package Script as shown below in red color:

PROMPT(SELECTINPUT,,,,,%TIME_DIM%)

PROMPT(COMBOBOX,%PRC%,"Select PRC:",0,,{TESTDIM})

'PROMPT(TEXT,%PRC%,"PRC",)

INFO(%EQU%,=)

'INFO(%TAB%,;)

TASK(/CPMB/RUNCALCACCOUNT_LOGIC,SUSER,%USER%)

TASK(/CPMB/RUNCALCACCOUNT_LOGIC,SAPPSET,%APPSET%)

TASK(/CPMB/RUNCALCACCOUNT_LOGIC,SAPP,%APP%)

TASK(/CPMB/RUNCALCACCOUNT_LOGIC,SELECTION,%SELECTION%)

TASK(/CPMB/RUNCALCACCOUNT_LOGIC,LOGICFILENAME,UJ_MAPPING_BR2.LGF)

TASK(/CPMB/RUNCALCACCOUNT_LOGIC,REPLACEPARAM,PRC%EQU%%PRC%)

My requirement is to pass this variable "%PRC%" in  script logic of account transformation business rule so that the business rule run for only members which are selected by user while running DMP.

Can anyone help me on how to call the variable in Script logic of Business Rule. I tried the as shown below in red color but it didn't work for me:

*RUN_PROGRAM CALC_ACCOUNT//

//*XDIM_MEMBERSET PRC as %GMS% = $PRC$

CATEGORY = ACT

CURRENCY = SEK

TID_RA = %TIME_SET%

AUDITID = BAS(ALL_DATASOURCES)

OTHER=[ENTITY=$PRC$]

CALC = EA_LOGIC

*ENDRUN_PROGRAM

Regards,

Apoorva

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jan 06, 2015 at 04:25 PM

    Hi Apoova,

    You have to understand that PROMPT(COMBOBOX... provide a selection from a FIXED list of values. Please read my post here:DM PROMPT(COMBOBOX behavior in BPC NW 10 and 7.5

    Vadim

    P.S. Not from dimension members - from fixed list of comma separated text strings!

    Add comment
    10|10000 characters needed characters exceeded

    • My understanding was that Apoorva wanted to select single member from restricted subset of members. RADIOBUTTON is an option only if you have small fixed list. COMBOBOX can be very long 😊

      Vadim

  • Jan 06, 2015 at 04:21 PM

    Hello Apoorva,

    What are you trying to get from that Combo box? As far as I can remember this type of PROMPT returns a comma separated list of selected values. I doubt you can use it in CALC_ACCOUNT.

    If you can explain what are you trying to achieve we can try to guide you how to get there.

    Regards,

    Gersh

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Gersh Voldman

      Hello Gresh,

      Yes I want user to select from subset of all members.

      That is why, I choose combo box functioanlity.

      Regards,

      Apoorva