EPM 10 selecting row member based on IF condition

[Former Member]

Hi Folks,

I am trying to recreate a BPC 7.5 static report in EPM 10. The BPC 7.5 report in the rows is taking the member value based on a IF condition, like:

Logic Source	USD Target	Non-USD Target	Row key range
DELL	DELO	DELP	DELP
IF condition used is:
IF(EVPRO($B$3,$B$13,"CURRENCY")="USD",F16,G16)

I have several rows for which I have to apply such logics individually. How can I achieve this. I am new to EPM 10 reporting...please help me.

Many Thanks

Vinay

[Former Member · Accepted solution]

Hi Vinay,

as Vadim says, without a proper description it is very difficult to answer your question, but you could try to build a report with the correct layout using the EPM Add-In by selecting the four elements for USD target as the row items.

Then in the EPMOlapMemberO function replace the first parameter with your if function (from BPC 7.5).

BR,
Arnold

[former_member186338]

Please provide the screenshot of the required report! The requirement can be achieved in different ways depending on report layout.

Vadim

[Former Member]

Hi Vadim,

Thanks for your response. Please find screenshot attached.

Regards,

Vinay

[former_member186338]

Sorry, but without the description of what you have on this screenshot it's not possible to answer. If you have no time to provide some useful info, then I have no time to answer...

[Former Member]

Hi Vadim,

Sorry about that.

Here is the explanation: In BPC 7.5: For the first column under Logic source there is a dimension member for which there are 2 possible dimension member values based on: if the currency property of Profit center dimension is USD or other than USD.  These values are put in the report sheet and we need to pick up that particular value based on a IF condition IF(EVPRO($B$3,$B$13,"CURRENCY")="USD",F16,G16), where profit center property CURRENCY is checked for USD or non USD currency, and put in the Row Key Range.

This is a static report.

As I am new to EPM 10, I am not sure how to implement this in EPM 10.

Thanks,

Regards,

Vinay

[former_member186338]

The simple way to do this:

Put in some cell the formula:

=If(EPMMemberProperty(...) ="USD", $F$16,$G$16)

Ensure that the result is correct.

Enable member recognition.

Then in the row axis paste this formula and it will be automatically inserted in the EPMOlapMemberO() formula

Done!

Vadim