Skip to Content
0
Former Member
Oct 06, 2009 at 05:56 PM

Problem passing variables from package to script logic

133 Views

Hi,

I'm working in BPC 7 MS SP05 (SQL2008) , and I 've one problem when i want to pass variables from a package to script logic.

I'm going to explain:

I want the user write one month and a percentage , THE first case runs OK but when i try to pass

two variables it fails:

package script:

PROMPT(TEXT,%MESES%,"Month",,)

PROMPT(SELECTINPUT,,,,%CATEGORY_DIM%)

TASK(Execute formulas,USER,%USER%)

TASK(Execute formulas,APPSET,%APPSET%)

TASK(Executeformulas,APP,%APP%)

TASK(Executeformulas,LOGICFILE,%APPPATH%\..\AdminApp\%APP%\V001_BE.lgf)

TASK(Execute formulas,FORMULASCRIPT,"FUNCTION VMESES=%MESES%")

script logic:

VMESES

But the problem it's when i want to introduce a new variable (percentaje):

package script:

PROMPT(TEXT,%MESES%,"Month",,)

PROMPT(TEXT,%PERC%,"Percent",,)

PROMPT(SELECTINPUT,,,,%CATEGORY_DIM%)

TASK(Execute formulas,USER,%USER%)

TASK(Execute formulas,APPSET,%APPSET%)

TASK(Executeformulas,APP,%APP%)

TASK(Executeformulas,LOGICFILE,%APPPATH%\..\AdminApp\%APP%\V001_BE.lgf)

TASK(Execute formulas,FORMULASCRIPT,"FUNCTION VMESES=%MESES%")

TASK(Execute formulas,FORMULASCRIPT,"FUNCTION VPERC=%PERC%")

script logic:

VMESES

VPERC

I This case , script logic not returns values .

So , I think that occurs because there are two lines of FORMULASCRIPT.

Exist another method of passing variables more easy , or how can I pass two variables by this way?

Thank your for your answers.