Skip to Content
0
Apr 24, 2020 at 04:15 PM

select statement to exclude the members in script

81 Views

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

Attachments

sl-cc24.jpg (29.3 kB)