Ambiguous Memberid, epm member property

[Former Member]

ss1.pngss2.pngss3.png@vadim k

i got an issue, related the same above of using epmmember property. i have added some employees in employee dimension master data. when i checked in IP, for few employees it is showing ambiguous member id. so what i did was, i added "Epmmemberid()" around all the memeber, then i issue was gone.actually this is for one profit center selectionss1.pngss2.png.

when i changed it to another profit center selection, the lines which has on employees shows correct in excel, the remaining lines where showing: Error: invalid memeberid. screenshotd attached. kindly may i know how i need to resolve this: Ambiguous memberid issue.

One employee detail in screenshot.ss3.png

[former_member186338]

Looks like you are not reading questions/answers in SAP Community...

I have posted hundreds of times NOT TO USE "Insert File" instead of correct "Insert Image"! I will not answer questions with "Insert File"!

P.S. And please read my comment here: https://answers.sap.com/comments/773792/view.html

[former_member186338 · Accepted solution]

If there is no data EPMMemberID will show this error! This is obvious!

You have to use IF to check content like:

=IF($A$20="";"";EPMMemberProperty(;EPMMemberID($A$20);"ACCTYPE"))

P.S. EPMMemberID will get member ID ONLY from cell in axis containing EPMOlapMemberO formula!

[former_member186338 · Accepted solution]

P.S. Also check option Repeat row/column headers

[Former Member · Accepted solution]

Thank you so much.. issue resolved

[Former Member]

Yes, there is no data.. My issue is, it should blank cell instead of that it is showing:

#Error - Invalid Member Name: #Not an EPMOlapMember formula

this error message should not come in excel.

In "Options", i kept : "Remove empty and Zero Values", but getting this error messages from rows 21 onwards..

[Former Member]

Still the same error.

[former_member186338]

Sorry, but I see nothing in $D$21 cell on your screenshot!

[former_member186338]

Sorry, but EPMMemberID has to reference cell containing formula like:

= EPMOlapMemberO(...

Sample:

P.S. For my local settings ";" is used instead of "," in Excel formulas.

[former_member186338]

P.P.S.

EPMMemberProperty function:

Look on EPMMemberID result

[Former Member]

sorry, for that.. i will make sure this will not happen in future.