Error with EPMMemberProperty Function

[Former Member]

Hi Experts,

I am facing an error when I am using EPMMemberproperty function in my report for display. In my requirement I have 2 dimensions Customer and Customer sold to party for which I have to display their properties in the report.

The error I face is when both ID's of the 2 dimensions are same i.e for e.g both member ID as "111", the function gives error #AmbiguousMemberID, and when I display both ID & description it gives another error as #Error- Invalid Member name "111".

I tried using EPMMemeberID in the EPMMemberProperty function, but it also doesnt seem to work. It also gives error. I have also tick marked the option for "Use EPMMemberID in EPM functions" from the "User Options". Also tried using EPMOlapMember, but no luck.

Attaching the screenshots of the error.

Currently  I am using EPM SP 16 patch 0 .NET framework 4.0.

Regards,

Priyanka

[former_member186338 · Accepted solution]

Hi Priyanka,

Use full unique member name in the formula (described in help!):

= EPMMemberProperty("ConName","[DIMNAME].[HIRNAME].["&C1&"]","PROPERTY")

Where in C1 you have short member id

Vadim

[Former Member · Accepted solution]

Thank you Vadim Sir.......

Sometimes when you work with deadlines, your brain stops working...........;)

Regards,

Priyanka

[former_member186338 · Accepted solution]

Have a nice day

Vadim

[asad_ahmed2]

= EPMMemberProperty(,"[DIMENSION_NAME].[PARENTH1].["&A2&"]","DESCRIPTION")

Replacce DIMENSION_NAME with your dimensison e.g. COMPANY

Replae A2 with your cell where Member ID is.

Should work like a charm

Thanks,

Asad Ahmed

[asad_ahmed2]

I see Mr. Vadim already answered this.

Thanks Sir.

[Former Member]

Hi Vadim,

I am also getting same error message..

I did apply your solution, but somehow formula was broken and not working.. so put it back to original formula and showing as below...

Please help me to correct with right formula..

[former_member186338]

And what do you have if you reproduce formula from my original answer?

[Former Member]

I was putting formula as below..

SF_ACCOUNT is Name of Dimension

ALL_ACCOUNTS is PARENTH1

D23 is : Cell to read Member Property member

PARENT_ACC_NAME is : Name of Property.

[Former Member]

Hi Vadim,

its working, I did overlook actual formula.

I followed as below to make it work..:)

[former_member186338]

Yes, the original formula has to work!