Skip to Content
author's profile photo Former Member
Former Member

Error with EPMMemberProperty Function

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Apr 03, 2014 at 06:49 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 26, 2016 at 07:45 PM

    = 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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.