Issue with Script Loic

[Former Member]

Hi,

I having issue with the below code..

*SELECT(%IN2_LIST1%,"[ID]",ACCOUNT,"[ALLOC]='Y_PL' ")

*XDIM_MEMBERSET ACCOUNT AS %IN2_LIST2% = BAS(LB20TCOS),BAS(LB20SAGE),BAS(LB30TLCC),BAS(LB40UNRC),BAS(LB50MISC),BAS(LB60INTE),BAS(LB70EQIN)

//*XDIM_MEMBERSET  ACCOUNT=BAS(LB10OPPR)
//*XDIM_ADDMEMBERSET ACCOUNT=ALINC
*XDIM_MEMBERSET  ACCOUNT=%IN2_LIST1%,ALINC // Added on 15-02-2013
*XDIM_MEMBERSET  CATEGORY=%CATEGORY_SET%
*XDIM_MEMBERSET  DATASRC=SYS_FR
*XDIM_MEMBERSET  ENTITY=9000
*XDIM_MEMBERSET  GROUPS=EQP
*XDIM_MEMBERSET  MARKET=M_FRA
*XDIM_MEMBERSET  PRODUCT=BAS(ALL_PRD)
*XDIM_MEMBERSET  PRODUCTSRC=BAS(ALL_PS)
*XDIM_MEMBERSET  PRODUCTTYPE=BAS(ALL_PRD_TYPE)
*XDIM_MEMBERSET  RPTCURRENCY=USD
*XDIM_MEMBERSET  SBU=AT
*XDIM_MEMBERSET  TIME=%TIME_SET%
*XDIM_MEMBERSET  MEASURES=YTD

*WHEN ACCOUNT
*IS ALINC

*FOR %IN2_LOOP1%=%IN2_LIST1%,%IN2_LIST2%

*REC(FACTOR=1, ACCOUNT=%IN2_LOOP1%, DATASRC=SYS_FR)

*NEXT

*ENDWHEN

this is bringing the accounts which doesn't have the Y_PL indicator also.. any help on this..

*COMMIT

[damovand]

Hello,

Reading through the script logic it seems to me that you are setting up the scope for account more than once which could be why you see accounts with Y_PL.

In the first place you are initializing %IN2_LIST1% just as accounts with ALLOC being Y_PL.

*SELECT(%IN2_LIST1%,"[ID]",ACCOUNT,"[ALLOC]='Y_PL' ")

But then you are adding to the scope by the following statement?  I couldn't find the specific syntax you are using for the *XDIM_MEMBERSET in the script logic primer document.  But I am assuming that you are adding the additional scope.

*XDIM_MEMBERSET ACCOUNT AS %IN2_LIST2% = BAS(LB20TCOS),BAS(LB20SAGE),BAS(LB30TLCC),BAS(LB40UNRC),BAS(LB50MISC),BAS(LB60INTE),BAS(LB70EQIN)

Finally the condition for the WHEN clause is account = ALINC.  Either %IN2_LIST2% after *XDIM_MEMBERSET or ALINC can include members without Y_PL.

Regards,

Leila Lappin