script logic

[Former Member]

Hi BPC Friend

I have a script logic with the following selection

*SELECT(%MYTIME%,"[ID]",TIME,BUDYEAR=$MONTHS$

where I can find what $MONTHS$ means?

Thanks

Michele

[Former Member · Accepted solution]

Hi Michele,

It must be a data manager variable.....Check the data manager package script.

Also read this Page no.16 http://assets.cdn.sap.com/sapcom/docs/2015/08/6cdcaf53-557c-0010-82c7-eda71af511fa.pdf

[former_member186338]

$MONTHS$ - is a variable passed from advanced DM script (look on DM package script!)

You can see this variable in the line with TASK REPLACEPARAM or MEMBERSECLECTION

[former_member186338]

P.S. Please show the text of your advanced DM script

[Former Member]

here you are

PROMPT(SELECTINPUT,,,,"%ENTITY_DIM%",,)

INFO(%FIX_SELECTION%,DIMENSION:CATEGORY|NYBUDGET|,DIMENSION:TIME|FY2017.010,FY2017.011,FY2017.012,FY2018.001,FY2018.002,FY2018.003,FY2018.004,FY2018.005,FY2018.006,FY2018.007,FY2018.008,FY2018.009,FY2018.010,FY2018.011,FY2018.012|)

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%%FIX_SELECTION%)

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

[former_member186338]

I don't see any assignment to the variable MONTHS in the advanced script. Looks like the script logic is not related to the current advanced script.

What do you want to achieve?

Please show full script logic text! And the explanation of logic

[Former Member]

I don't know because someone else wrote this script logic and I was wondering what $months$ means

[Former Member]

sorry It was right the advance script

INFO(%VAR%,B0)

INFO(%EQU%,=)

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,REPLACEPARAM,MONTHS%EQU%%VAR%)

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

[Former Member]

thanks, I understood

[former_member186338]

In TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,REPLACEPARAM,MONTHS%EQU%%VAR%)

you can see assignment of MONTH to be equal to VAR and VAR is:

INFO(%VAR%,B0)

But I see no line:

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

Required!

[former_member186338]

Without this line the variable will not be passed correctly!

[Former Member]

Sorry Vadim I am not an expert like you but is not this enough?

INFO(%VAR%,B0)

INFO(%EQU%,=)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,REPLACEPARAM,MONTHS%EQU%%VAR%)

[former_member186338]

No, this is NOT enough!

It's a special TASK:

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

[Former Member]

Hi Vadim in not that enough?

INFO(%VAR%,B0)

INFO(%EQU%,=)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,REPLACEPARAM,MONTHS%EQU%%VAR%)