Exclude members doesn't work when the dimensions are in axis override?

[chandrakanthk01]

Hi friends,

I want to exclude a member from Profit center PC_313 and this dimension is under axis override. The dimensions are Profitcenter, Company and Account,Cost center. Account and cost center are toggled with a drop down selection. So when I gave that PC_313 in exclude members, it is not excluding in the report. Attached is the screenshot for reference.

Appreciate if some one can help me..

[former_member186338]

Sorry, but can you create a better sample with clear formula! It's hard to understand what do you have....

[former_member186338]

Another option to exclude member - in the EPMAxisOverride formula:

"BAS(PL300);ID<>PL020" means:

BAS(PL300) - PL010, PL020, PL110, PL120

";" - AND

ID<>PL020

Result:

PL010, PL110, PL120

[former_member186338]

Please look on my test sample:

BAS(PL300) = PL010, PL020,PL110,PL120

Everything working correctly.

Start with simple case.

[chandrakanthk01]

Ok, I just need to exclude a member PC_313 from Profit center, Can I do it in EPM function, EPM context member? How do I filter it? I am trying like below:

Thanks,

Chandrakanth.K

[former_member186338]

How EPMContextMember is related to exclude in the report???