avatar image
Former Member

EPMMemberDesc EPMfunction does not work

Dear SAP BPC experts,

The following function is working fine because it selects the proper dimension property value to the page axis:

EPMDimensionOverride("000";"D_PLANYEAR";(EPMMemberProperty("PAR - PLANNING";"[D_PAR].[ID].[D_PLANYEAR]";"VALUE"))

I want to use the function EPMMemberDesc to show the value of the property D_PLANYEAR for the dimension D_PAR in the cell where this function can be found, but it does not show any value:

EPMDimensionOverride("000";"D_PLANYEAR";EPMMemberDesc((EPMMemberProperty("PAR - PLANNING";"[D_PAR].[ID].[D_PLANYEAR]";"VALUE")))

What is the problem with the function EPMMemberDesc

I am on SP22 EPM-add-in.

Thanks for your help,

Tamas

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

7 Answers

  • Best Answer
    Mar 26, 2017 at 11:54 AM

    Sorry, but I am unable to understand what are you doing!

    "But I cant see the real value of the dimension D_TERVEV since the system only says the expansion of D_TERVEV overriden."

    What for do you need EPMDimensionOverride???

    If you want to see just the value - in another cell put the formula:

    EPMMemberProperty("PAR - PLANNING";"[D_PAR].[PARENTH1].[D_PLANYEAR]";"VALUE")

    P.S. Why not to show full report screenshot instead of some strange header?

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 25, 2017 at 09:23 PM

    Sorry, but you are doing strange things...

    For the function:

    EPMDimensionOverride("000";"D_PLANYEAR";"SOME_MEMBERID")

    If you want to get Member ID from the property use EPMMemberProperty...

    P.S. The primary tag has to be: EPM Add-In for Excel

    P.P.S. The report sceenshot is welcome!

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 26, 2017 at 11:03 AM

    Hi Vadim, thanks for your answer.

    D_TERVEV (PLANYEAR) is read by the function EPMMemberProperty for the dimension ID D_PAR and then this value overrides the dimension D_TERVEV for the planning layout:

    But I cant see the real value of the dimension D_TERVEV since the system only says the expansion of D_TERVEV overriden. I tried to save data and the system is using the correct value of the property D_TERVEV for the dimension ID D_PAR.

    D_PAR dimension:

    I would like to see the value TEV2015 in the dimension D_TERVEV.

    Thanks,

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 26, 2017 at 11:17 AM
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 26, 2017 at 11:18 AM
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 26, 2017 at 08:49 PM

    EPMMemberProperty("PAR - PLANNING";"[D_PAR].[PARENTH1].[D_PLANYEAR]";"VALUE") is working fine.

    I am only doing the templates as per each modell and the report can read the major dimensions.

    Thanks for your help.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 29, 2017 at 12:10 PM

    This is the correct answer that has solved my problem. I can close the question based on this. Thanks for your help, Vadim.

    Add comment
    10|10000 characters needed characters exceeded

Skip to Content