Sum on local member EPM

[Former Member]

Hello experts,

I want to create a local member on rows (sum of two accounts).

I have thought two options (but I need help with second):

1. show this accounts and hide rows, then create localmember with EPMPosition(1)+EPMPosition(2).

2. I would like to sum directly ID of accounts on localmember. How can I do?

Thanks!

[former_member186338 · Accepted solution]

Hi Alex,

First option is correct, local members work only on data shown on the report.

As a bad alternative you can use EPMRetrieveData function in local member but it will affect the report performance.

Better:

You can also dimension member formula to get sum of 2 accounts

Or - the best - use hierarchy parent in the existing or new hierarchy.

Vadim

[Former Member · Accepted solution]

Thanks for your reply Vadim,

how can I use "You can also dimension member formula to get sum of 2 accounts"

For example to sum two accounts?

I should to type this forumula on a local member? Can you give an example of this?

Thanks

[former_member186338 · Accepted solution]

Dimension member formula is created in the WEB administration - in Rules!

Please read help: Member Formulas - SAP Business Planning and Consolidation, version for SAP NetWeaver - SAP Library

[former_member186338 · Accepted solution]

P.S. but hierarchy sum is better!

[Former Member · Accepted solution]

Thanks!

But I can't create hierarchy because in another reports I don't use this sum of accounts.

I'll try my first option or member formula on rules.

Thanks for your fast answers!

[former_member186338 · Accepted solution]

If this sum is specific to a single report, then the first option is better.

Instead of EPMPOSITION(1)... you can use:

=EPMMEMBER([CATEGORY].[].[FORECAST])+EPMMEMBER([CATEGORY].[].[ACTUAL])

sample from EPM help.

P.S. EPMMEMBER(...) will be replaced by the reference to the cell containing this member

[Former Member · Accepted solution]

Thanks again Vadim,

I think that EPMMember is better formula for my report.

Thanks!

[former_member186338 · Accepted solution]

Strange idea to mark the question as Assumed Answered - it means that you didn't received the correct answer....

[Former Member · Accepted solution]

Sorry, I fix it. Thanks!