Skip to Content
0
Dec 04, 2009 at 03:21 PM

NW 7.0 - Script Logic

28 Views

Hi team,

I have the next sentence:

*SELECT(%MES_ANT%,ID,TIEMPO,[ID]=[%TIEMPO_SET%].PREVMEMBER)

*SELECT(%SOCIEDADES%,ID,SOCIEDAD,"MONEDA_GRUPO='G_C441'")

*RUNALLOCATION

*NAME=OPENING_MONEDA_LOCAL

*FACTOR=1

*DIM TIEMPO WHAT=%MES_ANT%; WHERE=%TIEMPO_SET%

*DIM TIPO_MOVIM WHAT=F_CLO; WHERE=F_OPE

*DIM FUENTE_DATO WHAT=INPUT; WHERE=<<<

*DIM VERSION WHAT=ACTUAL; WHERE=<<<

*DIM CRITERIO_CONS WHAT=LC; WHERE=<<<

*DIM SOCIEDAD WHAT=%SOCIEDADES%;WHERE=<<<

*ENDALLOCATION

It is working perfeclty, But When I want to use a Variable for G_C441 like this:

TIME = 2008.Feb

CRITERIO_CONS = G_C441

*SELECT(%MES_ANT%,ID,TIEMPO,[ID]=[%TIEMPO_SET%].PREVMEMBER)

*SELECT(%SOCIEDADES%,ID,SOCIEDAD,[MONEDA_GRUPO]=[%CRITERIO_CONS_SET%])

*RUNALLOCATION

*NAME=OPENING_MONEDA_LOCAL

*FACTOR=1

*DIM TIEMPO WHAT=%MES_ANT%; WHERE=%TIEMPO_SET%

*DIM TIPO_MOVIM WHAT=F_CLO; WHERE=F_OPE

*DIM FUENTE_DATO WHAT=INPUT; WHERE=<<<

*DIM VERSION WHAT=ACTUAL; WHERE=<<<

*DIM CRITERIO_CONS WHAT=LC; WHERE=<<<

*DIM SOCIEDAD WHAT=%SOCIEDADES%;WHERE=<<<

*ENDALLOCATION

The program doesn't take the parameters and do it for all. Like it:

*DIM SOCIEDAD WHAT=;WHERE=<<<

SomeBody knows which could be the problems?

any suggestion I will appreaciate,

Thanks,

Leticia