Pass Dynamic Parameter in BPC 10 Microsoft

[Former Member]

I have

*REC(EXPRESSION = $AAA$, Account=Revenue)

and want to pass a dynamic value from Data Package. I tried these and none of them works (some are commented out below). Does anybody have a working sample in BPC 10 M? Thanks~

'DEBUG(ON)

PROMPT(SELECTINPUT,,,"Please select category, entity and time for restatement",%ENTITY_DIM%%TIME_DIM%)

PROMPT(TEXT,%AAA%,"Input a number here")

'INFO(%EQU%,=)

'INFO($AAA$,%AAA%)

TASK(Execute formulas,EQU,%EQU%)

TASK(Execute formulas,USER,%USER%)

TASK(Execute formulas,Environment,%Environment%)

TASK(Execute formulas,Model,%Model%)

TASK(Execute formulas,SELECTION,%SELECTIONFILE%)

TASK(Execute formulas,LOGICFILE,%ModelPath%\..\AdminApp\%Model%\Var Package.lgf)

TASK(Execute formulas,RUNMODE,1)

TASK(Execute formulas,LOGICMODE,1)

TASK(Execute formulas,CHECKLCK,%CHECKLCK%)

TASK(Execute formulas,REPLACEPARAM,AAA%EQU%%AAA%)

'TASK(Execute formulas,$AAA$,%AAA%)

'TASK(Execute formulas,%AAA%,%AAA%)

'TASK(Execute formulas,AAA,%AAA%)

[arun_varghese]

Hi Robert,

Please try this :

'DEBUG(ON)

PROMPT(SELECTINPUT,,,"Please select category, entity and time for restatement",%ENTITY_DIM%%TIME_DIM%)
PROMPT(TEXT,%AAA%,"Input a number here")

TASK(Execute formulas,USER,%USER%)
TASK(Execute formulas,Environment,%Environment%)
TASK(Execute formulas,Model,%Model%)

TASK(Execute formulas,SELECTION,%SELECTIONFILE%)
TASK(Execute formulas,FORMULASCRIPT,*FUNCTION AAA=%AAA%")

TASK(Execute formulas,RUNMODE,1)
TASK(Execute formulas,LOGICMODE,1)
TASK(Execute formulas,CHECKLCK,%CHECKLCK%)

TASK(Execute formulas,LOGICFILE,%ModelPath%\..\AdminApp\%Model%\Var Package.lgf)

[Former Member]

Hi Arun,

TASK(Execute formulas,FORMULASCRIPT,*FUNCTION AAA=%AAA%") didn't work, it is not a valid syntax. I also tried following they didn't work either:

'DEBUG(ON)

'PROMPT(RADIOBUTTON,%CHECKLCK%,"Select whether to check work status settings when running logic.",1,{"Yes, check for work status settings before running logic","No, do not check work status settings"},{"1","0"})

'PROMPT(SELECTINPUT,,,"No Need to Select Category",%ENTITY_DIM%%TIME_DIM%)

'PROMPT(TEXT,%AAA%,"Input a number here",,%AAA%)

PROMPT(TEXT,%AAA%,"Input a number here",,"")

TASK(Execute formulas,USER,%USER%)

TASK(Execute formulas,Environment,%Environment%)

TASK(Execute formulas,Model,%Model%)

'TASK(Execute formulas,SELECTION,%SELECTIONFILE%)

TASK(Execute formulas,LOGICFILE,%ModelPath%\..\AdminApp\%Model%\Var Package.lgx)

TASK(Execute formulas,RUNMODE,1)

TASK(Execute formulas,LOGICMODE,1)

'TASK(Execute formulas,CHECKLCK,%CHECKLCK%)

'TASK(Execute formulas,FormulaScript,AAA=%AAA%)

TASK(Execute formulas,AAA,%AAA%)

'TASK(REPLACEPARAM,AAA,%AAA%)