EPMContextMember "OR" Selection

[Former Member]

Dear Experts,

I have a requirement to have a selection cell in EPM Input Forms where the selection is filtered to select only base members of a hierarchy node or one single outside of this hierarchy node.

In my testing, with semicolon between filters I've noticed that if I use the same "property" (PARENTH1 in this case) with semicolon means "OR", but filtering by different properties means "AND"... Sounds weird but It's what I've seen so far.

=EPMContextMember(,"ACCOUNT","PARENTH1=NodeA;PARENTH1=NodeB")

This results in PARENTH1 = NodeA OR NodeB

=EPMContextMember(,"ACCOUNT","PARENTH1=NodeA;PROP=ValueB")

This results in PARENTH1 = NodeA AND PROP=ValueB

Using the second sentence filtering by a hierarchy node and ID ("PARENTH1=NodeA;ID=Account1") gives me a empty selection given that there are no accounts that meet both filters ath the same time ("AND" selection...).

Is there a way to get an "OR" sentence when filtering by different properties in EPMContextMember or EPMSelectMember or is there a work around this situation?

Thank you all for your time. I hope we can find a solution as I think I'm not the only one with this requirement.

Using:

BPC 10.1 NW Classic SP4

EPM Add-In 10 SP20 Patch2 .NET 4.0.

Best regards,

Joaquin Price

[former_member193143 · Accepted solution]

Hello Prince,

as you said, it should work in this way

=EPMContextMember(,"scenario","PARENTH1=BP_NODE;PARENTH1=ACT_NODE")

The other way you asking is not possible as far as I know...

if you use like that it will pop-up a empty screen

Regards,

Saida Reddy G

[former_member186338]

H Joaquin,

Unfortunately "Is there a way to get an "OR" sentence when filtering by different properties in EPMContextMember or EPMSelectMember or is there a work around this situation?" - not possible!

"," - that has to be used as OR is not working with EPMSelectMember ...

Vadim