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