Skip to Content
avatar image
Former Member

duplicated line EPM

Hi guys,

I don't understand why in my report the line is dupliacted. Is something wrong in my member selector parameters?

Thanks.

Amine

sans-titre.png (98.1 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • Sep 21, 2017 at 01:48 PM

    Sorry, looks like you playing with the report developed not by you!

    Please start from the very beginning:

    1. Create a new, simple report.

    2. Use some cell for =EPMContextMember("OVERHE";"OH_ORGA")

    3. Use this cell for report - no idea how do you want to use it!

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 21, 2017 at 01:00 PM

    Here is the formula:

    = EPMOlapMemberO("[OH_ORGA].[PARENTH1].[SOSA_200004]";"";"SOSA_200004";"";"000")

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 21, 2017 at 01:07 PM

    Hi Vadim,

    Thanks for your answer. I selected only one, may be there is a problem in my EPM formula?

    Add comment
    10|10000 characters needed characters exceeded

    • Please, don't change anything in EPMOlapMemberO function manually!

      As I already told you, remove selection for OH_ORGA dimension at all, then select a single member!

  • avatar image
    Former Member
    Sep 21, 2017 at 02:47 PM

    Hi Vadim,

    I think i founfd the source of my problem.

    I found a cell with this formula :=EPMDimensionOverride("000";"OH_ORGA";"SELF("&$A$2&"),BAS("&$A$2&")")

    Thanks.

    Amine

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 21, 2017 at 01:03 PM

    First of all - incorrect tag:

    SAP Business Planning and Consolidation, version for SAP NetWeaver

    Please change to:

    EPM Add-In for Excel

    Second - "I don't understand why in my report the line is dupliacted" - you managed to select the same member twice!

    It's possible! Simply remove selection and select again. I do not understand what do you want to select...

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 21, 2017 at 03:21 PM

    For sure if $A$2 is a base member you will get two identical lines because in this case:

    BAS($A$2)=$A$2

    Use:

    =EPMDimensionOverride("000";"OH_ORGA";"SELF("&$A$2&")"&IF(EPMMemberProperty(;$A$2;"CALC")="Y";",BAS("&$A$2&")";""))

    If CALC =N then BAS(A2) will not be added!


    Add comment
    10|10000 characters needed characters exceeded