Skip to Content
avatar image
Former Member

Double Members after Hierarchy change

Dear Experts,

we are facing an issue on BPC 10.1 Standard on HANA.

If we are changing the hierarchy e.g. in Time Dimension by pulling 2017.TOTAL below 2016.TOTAL we are getting an error when processing.

the Error is: Detected dublicate Member ID (in this case 2017.Total).

This happns to all Dimensions.

System:

BW: 740 SP014

CPMBPC: 810 SP009

POASBC: 100_731 SP006

HANABPC: 810 SP009

Thanks

Johannes

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

7 Answers

  • Best Answer
    avatar image
    Former Member
    Feb 28, 2017 at 05:09 PM

    Hi Vadim,

    Thanks for your Help.

    In the End, it turns out that Note

    https://launchpad.support.sap.com/#/notes/2404956/E

    is solving the issue, I do not exactly understand why...

    Cheers

    Johannes

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 14, 2017 at 08:24 PM
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 14, 2017 at 02:00 PM

    unbenannt.jpgThe Error Message:

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 14, 2017 at 02:49 PM

    TIME dimension is a special dimension with some rules for hierarchy and properties!

    Please show screenshot of your existing TIME dimension administration and explain the change you want to perform!

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 14, 2017 at 04:55 PM

    HI Vadim,

    you are completely right, but we are facing the same issue in User defined dimensions.

    Actually Time is not really the problem, I thought this will be a good example and standarized for a lot of applications.

    The problem occur in each dimension.

    Add comment
    10|10000 characters needed characters exceeded

    • Can you explain your actions step by step with some screenshots? Not 100% clear what are you doing...

  • avatar image
    Former Member
    Feb 14, 2017 at 07:01 PM

    Hi Vadim,

    unbenannt.jpg

    actually I am trying to change the sequence of a hierarchy.

    When doing so, the moved member gets double in the dimension and the process fails.

    This is happening in all dimensions.

    Thanks

    Johannes

    Add comment
    10|10000 characters needed characters exceeded

    • Unable to test it in BPC 10.1, but in BPC 10 Environmentshel copy it's working fine (just tested on the ACCOUNT dimension). Hope you have single hierarchy in the dimension?

  • avatar image
    Former Member
    Feb 14, 2017 at 07:17 PM

    actually no, but it should not matter.

    We opened a Ticket, but no solution yet, I could not find anything in SAP Notes and hope that someone already faced this issue.

    Add comment
    10|10000 characters needed characters exceeded

    • Read notes :)

      Looks like SP11 has some fixes!