How to exclude some members in script logic scoping

[Former Member]

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

[former_member186338]

On some resent SP of BPC 10 you can use the following:

//%ABAS% will store all BAS accounts

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

*SELECT(%ABASEXCL%,"[ID]",ACCOUNT,"[ID]=%ABAS% AND [ID]<>CAIN00500000,CAIN00500001)

*XDIM_MEMBERSET ACCOUNT=%ABASEXCL%

Vadim

[former_member186338]

Hi Praveen,

Please describe in details your account dimension! May be it's possible to create some SELECT.

Vadim

P.S. And please, provide your core BPC version and SP!

[Former Member]

Hello Vadim, All the Accounts BAS(FUCS157),BAS(FUCS156),BAS(FUCS155),BAS(FUCS154),BAS(FUCS165),BAS(FUCS164)

All the Accounts are "EXPENSES" And fall under manufacturing expense heads. For Few GLs planning is happening at different places like "Raw Material Expenses". Planning value is coming from Production Planning also from Cost Center Planning. Except These GLs all the other expenses are coming from single location i.e. Cost Center Planning.  The above GL (CAIN00500000 - Raw Material Expenses) fall under "FUCS164" Head.

Thanking you

Praveen

[former_member186338]

Hi Praveen,

Why do you ignore the question: "And please, provide your core BPC version and SP!"

The code behavior depends on this info!

Have you tried code below?

On my system:

It's working fine!

Vadim

[Former Member]

Hello Vadim,

This is the system information

Why do you ignore the question?

As i Said this GL gets Plan Data From Two different contexts. One Value come from the same location and Other Value come from Other Planning area. I need to merge these two values and bring it to this destination

For Example

Plan -> Production Planning - Raw Material Expense = 1000

Plan -> Cost Center Planning - Raw Material expense = 500

I need to Combine Both the values -> Raw Material Expense = 1500

The logic above will get Cost Center values only.

*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

I am working on the logic above.

Thank you

Praveen

[former_member186338]

The original question was how to exclude particular member (or members) from the scope defined as BAS(...),BAS(...)...

And this question was answered by the code here:

Now you are asking about data coming from different contexts... Without explanation - what do you mean by context!

Cost Center Planning

*XDIM_MEMBERSET COST_CENTER = BAS(SIL COMANCCKDG)

Production Planning

????