on 04-24-2020 5:15 PM
Hi Experts
Need to exclude few costcenter members in Parenth2(only BA00).
I have huge cc members to exclude (BA00). Is there any way to exclude the members with logic Can some one please help me in select statement.
*XDIM_MEMBERSET COSTCENTER AS %TL%= BAS(TOTAL)
*SELECT(%B00%,"[ID]", COSTCENTER, "[ID] = %TL% AND <> [PARENTH2]=B00'")
*XDIM_MEMBERSET COSTCENTER =%B00%
Thanks
KishoreV
You can use the following:
*XDIM_MEMBERSET ACCOUNT AS %A1%=BAS(PL600)
*XDIM_MEMBERSET ACCOUNT = %A1%
*XDIM_MEMBERSET ACCOUNT AS %A2%=BAS(PL200)
*XDIM_MEMBERSET ACCOUNT = %A2%
*SELECT(%A3%,ID,ACCOUNT,ID=%A1% AND ID<>%A2%)
*XDIM_MEMBERSET ACCOUNT = %A3%
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
P.S. Result in UJKT:
LGX:
*XDIM_MEMBERSET ACCOUNT = PL010,PL020,PL110,PL120,PL310,PL320,PL330,PL510,PL999
*XDIM_MEMBERSET ACCOUNT = PL110,PL120
*XDIM_MEMBERSET ACCOUNT = PL010,PL020,PL310,PL320,PL330,PL510,PL999
valluru
Already tested 🙂
In your case the code will be:
*XDIM_MEMBERSET COSTCENTER AS %A1%=BAS(TOTAL)
*XDIM_MEMBERSET COSTCENTER = %A1% //just for test
*XDIM_MEMBERSET COSTCENTER AS %A2%=BAS(BA00)
*XDIM_MEMBERSET COSTCENTER = %A2% //just for test
*SELECT(%A3%,ID,COSTCENTER,ID=%A1% AND ID<>%A2%)
*XDIM_MEMBERSET COSTCENTER = %A3% //result of select
Hi Experts
Created property in CC to exclude. can some one correct below SL.
*XDIM_MEMBERSET COSTCENTER AS %CC%= BAS(TOTAL)
*SELECT(%B00%,[ID],COSTCENTER,[BA]<>BA00)
*XDIM_MEMBERSET COSTCENTER =%B00%
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
sreeraj.sukumaran
When I tested in UJKT : say's invalid select statement.
Seems select statement not recognizing the parent hieararcy.
Is there any other statement which can work for parent group exclude.
Thanks for help
Kishore V
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
*XDIM_MEMBERSET COSTCENTER AS%TL%= BAS(TOTAL)
*SELECT(%B00%,"[ID]", COSTCENTER, "[ID] = %TL% AND [PARENTH2] <> BA00'")
*XDIM_MEMBERSET COSTCENTER =%B00%
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
12 | |
4 | |
2 | |
2 | |
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.