Skip to Content
avatar image
Former Member

set dynamic member to dimension in *REC statement

BPC Experts,

Please refer to the below script logic . In this i wanted to pass the dynamic value to the BPC dimension. For the INPUT auditidm , i want to update different AUDITID value based on the dynamic selection in BPC . But the below script logic is throwing warning message and the dynamic value to the auditid is not considered, instead it uses the variable name itself while generating the records. I m using BPC 10 version SP Level 12.

*XDIM_MEMBERSET CATEGORY = %CATEGORY_SET%

*XDIM_MEMBERSET TIME = %TIME_SET%

*XDIM_MEMBERSET ACCOUNT = %ACCOUNT_SET%

*XDIM_MEMBERSET AUDITIDM= INPUT

*WHEN AUDITIDM

*IS *

*REC(EXPRESSION = %VALUE% * ($PER_INPUT$/100), AUDITIDM = $HLA_INPUT$ )

*ENDWHEN

*COMMIT

PROMPT(SELECT,,,,"CATEGORY,ACCOUNT,TIME,")

PROMPT(TEXT, %PER_INPUT%, "Input Percentage",,)

PROMPT(COMBOBOX, %HLA_INPUT%, "Select HLA AudiitID from the list",0,"HLA_01",{"HLA_02","HLA_03","HLA_04"},)

INFO(%EQU%,=)

INFO(%TAB%,;)

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

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

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

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

TASK(/CPMB/FX_RESTATMENT_LOGIC,REPLACEPARAM,PER_INPUT%EQU%%PER_INPUT%%TAB%,AUDITIDM%EQU%%HLA_INPUT%)

TASK(/CPMB/FX_RESTATMENT_LOGIC,LOGICFILENAME,HLA.LGF)

After the run package, warning messages shows

ENDWHEN ACCUMULATION: 1  RECORDS ARE GENERATED.

Invalid Members [AUDITIDM]=%HLA_INPUT%

How to pass dynamic value to the REC statement ? Please provide your inputs

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Jan 14, 2015 at 08:29 AM

    TASK(/CPMB/FX_RESTATMENT_LOGIC,REPLACEPARAM,PER_INPUT%EQU%%PER_INPUT%

    %TAB%,AUDITIDM%EQU%%HLA_INPUT%) -> you have given comma after %TAB% remove that and use HLA_INPUT not AUDITIDM


    Correct:

    TASK(/CPMB/FX_RESTATMENT_LOGIC,REPLACEPARAM,PER_INPUT%EQU%%PER_INPUT%

    %TAB%HLA_INPUT%EQU%%HLA_INPUT%)


    Also remove inverted comma in combo box.


    Correct:

    PROMPT(COMBOBOX, %HLA_INPUT%, "Select HLA AudiitID from the list",0,HLA_01,{HLA_01,HLA_02,HLA_03,HLA_04},)


    Hope this helps..


    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 13, 2015 at 04:03 PM

    Hi,

    just try with below line

    PROMPT(COMBOBOX, %HLA_INPUT%, "Select HLA AudiitID from the list",0,HLA_01,{HLA_02,HLA_03,HLA_04})

    Might be error in combo box prompt please go through below link might be helpful.

    DM PROMPT(COMBOBOX behavior in BPC NW 10 and 7.5

    also go through below link

    http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/d01ce779-f1b2-2b10-07ba-da3734013245?QuickLink=index&…

    Regards,

    Sushant

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 13, 2015 at 06:41 AM

    In the above discussion, How to get dynamic value to the REC statement in order to create records and update the dimension member to the system based on user selection ?

    Add comment
    10|10000 characters needed characters exceeded