EPMCONTEXTMEMBER "OR" filtering

[Former Member]

Hi Experts,

I need to use a filter in function EPMCONTEXTMEMBER that shows the sum (OR) of two conditions.

here is the example:

• condition 1: PROFIT_CENTER.BU = BU1
• condition 2: PROFIT_CENTER.BU = BU2, PROFIT_CENTER.PLAN = Y

I would like to receive in the member selector of EPMCONTEXTMEMBER all the Profit Centers that belong to BU1, plus only the Profit centers of BU2 with PLAN equal Y

have you ever faced the same problem?

is creating a new property the only solution to my issue?

thanks for your help

Daniele

[former_member186338]

"I would like to receive in the member selector of EPMCONTEXTMEMBER all the Profit Centers that belong to BU1, plus only the Profit centers of BU2 with PLAN equal Y" - not possible!

[former_member186338]

something can be done only for direct children of BU1 an BU2 using PARENTH1

Ups sorry, didn't understand that BU is a property...

[former_member186338]

Not possible but due to different reason:

You can't create condition like:

(PROP1=VAL1) OR (PROP1=VAL2 AND PROP2=VAL3)

only ";" is supported

[Former Member]

Thanks Vadim, I'll try with a workaround.

[former_member186338]

EPMCONTEXTMEMBER filter is limited to ";" compared with dimensionoverride...

You can't do a lot

Sample:

PROP1=VAL1;PROP1=VAL2;PROP2=VAL3

Will result in:

((PROP1=VAL1) OR (PROP1=VAL2)) AND (PROP2=VAL3)

[Former Member]

Hey Vadim....

A simple OR is also not supported in Context member? Why so?

JP

[former_member186338]

"Why so?" - ask EPM developers

";" will be AND for different properties and OR for the same property!

[Former Member]

.....Should place this idea in the SAP Idea Place...Thanks anyway....

Regards,

JP

[former_member186338]

May be it's already here It was already discussed number of times with no effect.

For some reason the EPM developers decided to use ";" syntax instead of normal logic conditions with "AND","OR","NOT","(",")", etc...

[Former Member]

Hi Daniele,

here is one working example: AND ; condition

Please note you can use only AND or only OR throughout the condition. Cant use both together. As the document suggested by Andy also shows it....Tested in system.

Regards,

JP

[Former Member]

Hi,

my real problem is to filter with an OR condition, I'm quite familiar with AND condition,

please check my answer to Andy Xu where there is a more detailed screen.

many thanks for your contribution.

[Former Member]

Daniele,

Dont refer just one cell for the condition, it will not work! Please specify the formula as given in my screenshot! Refer the property values with cell reference.....Instead of AND condition use OR in my screenshot and it will work!

Please try this way......

Regards,

JP

[Former Member]

Tried, but same result

my EPM-Addin is the following:

[Former Member]

Upgrade your EPM Add-In to latest one...24!

In your formula after Connection name and dimension name it should be "," instead of ";".

Can you show the display of the formula screenshot(fx)?

Regards,

JP

[Former Member]

Hi Daniele,

Looks like OR "," is not supported in EPMCONTEXTMEMBER function just tested all possibllities. Sorry couldnt help!

Regards,

JP

[Former Member]

Thanks anyway for trying!

[Former Member]

Hi Daniele,

You can combine those conditions in one line with and (;) or (.) symbols.

no need for new property.

Andy

[Former Member]

Hi, I already saw that document but it is referring to function EPMDIMENSIONOVERRIDE.

I am not able to replicate on function EPMCONTEXTMEMBER.

please see below:

in the first case the member selector shows the correct dimension members, in the second case as you can see seems that the format of the filter is not valid and it is not applied at all.

many thanks for your contribution.

[Former Member]

Hi Daniele,

Is PLAN another property of PROFIT_CENTER dimension??

Regards,

JP

[Former Member]

Yes it is