Skip to Content
0
Former Member
Oct 06, 2014 at 07:42 AM

How to exclude some members in script logic scoping

590 Views

Good Morning Experts. I need your help. In the scoping for Account dimension, I need to exclude few members (ex:- CAIN00500000) from the scoping. Please guide me how to exclude it out from the logic.

If i have to use filter i need to create a property for the required members only and then use it in scoping. But there are a huge number of members which have to be updated with a property and also continuous admin task has to be performed. is There any simple way to exclude members from scoping?

Below is my logic

=================

*XDIM_MEMBERSET CATEGORY = Plan

*XDIM_MEMBERSET RPTCURRENCY = LC

*XDIM_MEMBERSET PLANT = NO_PLANT

*XDIM_MEMBERSET CUSTOMER_SALES = NO_CUSTOMER

*XDIM_MEMBERSET PRODUCT = NO_PRODUCT

*XDIM_MEMBERSET UOM = AMT

*XDIM_MEMBERSET COST_CENTER = BAS(SIL COMANCCKDG)

*XDIM_MEMBERSET ACCOUNT = BAS(FUCS157),BAS(FUCS156),BAS(FUCS155),BAS(FUCS154),BAS(FUCS165),BAS(FUCS164)

*WHEN PLANT

*IS NO_PLANT

*REC(EXPRESSION=%VALUE%, PLANT = PLANT1)

*ENDWHEN

Thanking you In advance

Praveen