on 10-06-2014 6:20 AM
Hello All,
I am getting value multiplied by 2 in below script logic:
*XDIM_MEMBERSET MODEL=%ASTOCK1%
*XDIM_MEMBERSET SLSACCOUNT=SALES_UNIT, SAIR_REBATE_PER_UNIT,SMIR_REBATE_PER_UNIT,BMIR_REBATE_PER_UNIT,BIR_REBATE_PER_UNIT,ABR_REBATE_PER_UNIT,DCR_REBATE_PER_UNIT
*XDIM_MEMBERSET CUSTOMER=<ALL>
*XDIM_MEMBERSET CHANNEL=<ALL>
*XDIM_MEMBERSET AUDITTRAIL=INPUT
*WHEN MODEL.CALC_QTY_DRIVEN_ACCT
*IS <> "N"
*WHEN SLSACCOUNT
*IS SALES_UNIT
*REC(EXPRESSION=[SLSACCOUNT].[SAIR_REBATE_PER_UNIT]*[SLSACCOUNT].[SALES_UNIT]*-1, SLSACCOUNT="SAIR_REBATE_CALC")
*ENDWHEN
*WHEN SLSACCOUNT
*IS SAIR_REBATE_PER_UNIT,SMIR_REBATE_PER_UNIT,BMIR_REBATE_PER_UNIT,BIR_REBATE_PER_UNIT,ABR_REBATE_PER_UNIT,DCR_REBATE_PER_UNIT
*REC(EXPRESSION=[SLSACCOUNT].[SAIR_REBATE_PER_UNIT]*[SLSACCOUNT].[SALES_UNIT]*-1, SLSACCOUNT="SAIR_REBATE_CALC")
*ENDWHEN
*ENDWHEN
*COMMIT
but not getting correct value. Could anyone please help me in this?
Beat Regards,
Deepak Palsaniya
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
Below is full script code:
*SELECT(%ASTOCK1%,"[ID]","MODEL","STOCKSTATUS='ASTOCK'")
*XDIM_MEMBERSET MODEL=%ASTOCK1%
*XDIM_MEMBERSET SLSACCOUNT=SALES_UNIT, SAIR_REBATE_PER_UNIT,SMIR_REBATE_PER_UNIT,BMIR_REBATE_PER_UNIT,BIR_REBATE_PER_UNIT,ABR_REBATE_PER_UNIT,DCR_REBATE_PER_UNIT
*XDIM_MEMBERSET CUSTOMER=<ALL>
*XDIM_MEMBERSET CHANNEL=<ALL>
*XDIM_MEMBERSET AUDITTRAIL=INPUT
*WHEN MODEL.CALC_QTY_DRIVEN_ACCT
*IS <> "N"
*WHEN SLSACCOUNT
*IS SALES_UNIT
*REC(EXPRESSION=[SLSACCOUNT].[SAIR_REBATE_PER_UNIT]*[SLSACCOUNT].[SALES_UNIT]*-1, SLSACCOUNT="SAIR_REBATE_CALC")
*ENDWHEN
*WHEN SLSACCOUNT
*IS SAIR_REBATE_PER_UNIT
*REC(EXPRESSION=[SLSACCOUNT].[SAIR_REBATE_PER_UNIT]*[SLSACCOUNT].[SALES_UNIT]*-1, SLSACCOUNT="SAIR_REBATE_CALC")
*ENDWHEN
*ENDWHEN
*COMMIT
Please use the following code:
*SELECT(%ASTOCK1%,"[ID]","MODEL","[STOCKSTATUS]='ASTOCK' AND [CALC_QTY_DRIVEN_ACCT]<>'N'")
*XDIM_MEMBERSET MODEL=%ASTOCK1%
*XDIM_MEMBERSET AUDITTRAIL=INPUT
// Clear destination
*XDIM_MEMBERSET SLSACCOUNT=SAIR_REBATE_CALC
*WHEN SLSACCOUNT
*IS *
*REC(EXPRESSION=0)
*ENDWHEN
// Calculate [SLSACCOUNT].[SAIR_REBATE_PER_UNIT]*[SLSACCOUNT].[SALES_UNIT]
*XDIM_MEMBERSET SLSACCOUNT=SALES_UNIT
*WHEN SLSACCOUNT
*IS *
*REC(EXPRESSION=%VALUE%*[SLSACCOUNT].[SAIR_REBATE_PER_UNIT], SLSACCOUNT="SAIR_REBATE_CALC")
*ENDWHEN
Never use COMMIT, useless!
Vadim
User | Count |
---|---|
6 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.