Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

Former Member
Former Member replied

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..


0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question