set dynamic member to dimension in *REC statement

[UmaArjunan]

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

[bhagyesh_ravange · Accepted solution]

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

[UmaArjunan · Accepted solution]

thank you very much for your help, it is working now as per the selected value in the COMBO box.

Could you pl. share the docs to quickly check all the syntax formulated for BPC 10. apart from HELP.SAP ?

Is there any easy way to check the syntax  or extra symbols for the scripts ?

[bhagyesh_ravange · Accepted solution]

Hello.

Please refer below document for script logic:

http://www.cjcsc.cn/ToolsShare/BPC/book/Script+logic+Getting+Started.pdf

Please refer below document for EPM Add in:

http://help.sap.com/businessobject/product_guides/boeo10/en/EPMofc_10_user_en.pdf

Regards

Bhagyesh Ravange

[Former Member]

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.

also go through below link

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/d01ce779-f1b2-2b10-07ba-da3734013...

Regards,

Sushant

[UmaArjunan]

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 ?