Skip to Content
0
Jan 03, 2013 at 10:05 PM

*SELECT and %TIME_SET%

57 Views

Hello everyone, if could help with this script.

*INCLUDE SYSTEM_CONSTANTS.LGL*SYSLIB  SYSTEM_LIBRARY.LGL   *SELECT (%MES%,[MESES],TIME,[ID] = '%TIME_SET%')*XDIM_MEMBERSET ENTITY=1,1USD*XDIM_MEMBERSET DEPENDENCIA=135,138,147,154,179*XDIM_MEMBERSET RPTCURRENCY=GTQ*XDIM_MEMBERSET TIME = %MES%*DESTINATION_APP =TARJETA*SKIP_DIM = AGENCIA*SKIP_DIM = DEPENDENCIA*SKIP_DIM = PLAZA*RENAME_DIM ACCOUNTGASTO = ACCOUNTTAR*WHEN TIME          *IS %MES%                    *WHEN ACCOUNTGASTO.TARJETATRASLADO                                        *IS S                                                  *REC(EXPRESSION = %VALUE%,ACCOUNTGASTO=ACCOUNTGASTO.TARJETACCOUNT,DATASRC=INPUT,ENTITY=1,RPTCURRENCY=LC,TIME = %TIME_SET%)                    *ENDWHEN*ENDWHEN*COMMIT

This script does not work, but if I change the %TIME_SET% for a date X in the SELECT, work fine.

If anyone has any suggestions or something I'm missing in the script, thank you for advance

Note: This script works in Netweaver but in MS not working.