Skip to Content

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

Modify package: Prompt Text and Pass to Scripts

Hi Experts,

I'm trying to setup a package list to allow users enter a value (A,B,C) of a Dimension [COSTCENTER] Property [BU] and then pass this value to the script as scoping/filter, but have some issues.  We are using NW10, SP15.

The Prompt setting is: PROMPT(TEXT, %BU%, "Select Business Unit to run",,,,,")

I have two script scoping and both of them have some issues:

Scoping 1 uses Select function; This one works, but it works on ALL COSTCENTER, i.e. if I enter "A", the calculation is performed for ALL COSTCENTER member

*SELECT(%BU_SEL%,"ID","COSTCENTER",BUSINESS_UNIT=%BU%)

*XDIM_MEMBERSET COSTCENTER=%BU_SEL%

Scoping 2 doesn't pass the script validation. The error is "No member found in Dimension "COSTCENTER" for condition "CALC"="N".  But there are base members with the property properly tagged.

*XDIM_FILTER COSTCENTER = [COSTCENTER].properties("BU")="%BU%"

Any suggestion? Thanks in advance.

Ben

replied

Hi Ben,

This script:

PROMPT(SELECTINPUT,,,,"%CATEGORY_DIM%,%TIME_DIM%")

PROMPT(TEXT, %BU%, "Select Business Unit to run earning calculation",,,,,")

INFO(%EQU%,=)

INFO(%TAB%,;)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,EQU,%EQU%)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,TAB,%TAB%)

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

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

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

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

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,LOGICFILENAME,WIP_CM_DEFAULT_BU.LGF)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,REPLACEPARAM,BU%EQU%%BU%)

Will pass to the script logic variable $BU$ that will be used in *SELECT(...

Vadim

0 View this answer in context

Helpful Answer

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