Skip to Content
avatar image
Former Member

EPMMemberProperty and #REF!

Hi All,

Can #REF! be used as a parameter in EPMMemberProperty?
Along the lines of EPMMemberProperty(A3,#REF!,A4)?
Does it look for a dimension member #REF?

Lucy

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Aug 13, 2017 at 08:13 AM

    #REF - means the error in the formula like non existing reference.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 14, 2017 at 08:25 AM

    why then have it as a parameter in the EPMMemberProperty?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 15, 2017 at 08:42 AM

    Ok here's another one..

    I have this cell formula

    =IF(AB11="","",IF(ISERROR(SEARCH("#Error",EPMMemberProperty("This_Model",AB11,"ACCOUNT"))),EPMMemberProperty("This_Model ",AB11,"ACCOUNT"),""))

    I understand EPMMemberProperty("This_Model ",AB11,"ACCOUNT") returns the Account parameter value. But what is this bit below doing?

    IF(ISERROR(SEARCH("#Error",EPMMemberProperty("This_Model",AB11,"ACCOUNT"))

    Is it searching for #Error in the ACCOUNT parameter of the member housed in AB11?

    Lucy

    Add comment
    10|10000 characters needed characters exceeded

    • Sorry, but you need some Excel training...

      EPMMemberProperty("This_Model",AB11,"ACCOUNT") - can return "#Error" if there is no connection or some other cases

      SEARCH("#Error",EPMMemberProperty("This_Model",AB11,"ACCOUNT")) will return 1 if "#Error" is found or Excel error "#VALUE!"

      ISERROR(SEARCH("#Error",EPMMemberProperty("This_Model",AB11,"ACCOUNT"))) will return TRUE if "#Error" is NOT found and FALSE if found