Skip to Content
avatar image
Former Member

SAP BPC Member Formulas - duplicate member ID

Hi Community,

we've updated BPC to

  • HANABPC 810 SP11
  • CPMBPC 810 SP 11
  • BW 740 SP 16

and now there's an issue with member formulas.

HANA MDX is activated

All formulas are green on the overview sheet but they don't show any result in Excel. If we try to re-activate them, they appear twice in the list. One green / one yellow and on activation I get: duplicate member ID - error

Any idea on that?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

10 Answers

  • Feb 24, 2017 at 09:15 AM

    Start with tests on ENVIRONMENTSHEL copy... Create single simple formula...

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 24, 2017 at 09:56 AM

    Hi Vadim,

    I've copied ENVIRONMENTSHEL and I've the same problem

    It appears even without

    • Global: ENABLE_ACCELERATOR = X
    • Environment: ACCELERATOR_ON = X
    • Model: ENABLE_HANA_MDX = X

    At the beginning I thought it's a problem of the HANA Acceleration but it might be something else ...

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 24, 2017 at 10:15 AM

    Hi,

    only one formular seems to work. The 2nd Formular appears twice after activation

    pic-1.png

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 24, 2017 at 10:54 AM

    Please search notes for: "BPC Member Formulas duplicate member ID"

    https://launchpad.support.sap.com/#/notes/1970585

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 24, 2017 at 11:03 AM

    I've tried UJHANA_REFRESH_VIR_CUBE already but it hasn't changed anything

    and I cannot find anything in SAP notes

    Seems like a bigger problem

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 24, 2017 at 11:07 AM

    this one looks good

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

    but we are already on sp16

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 24, 2017 at 12:44 PM

    yes, that's true ...

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 24, 2017 at 01:15 PM

    when I excecute a single Formula in Excel I've an error message with

    <HTML><HEAD> <TITLE>500 SAP Internal Server Error</TITLE> </HEAD><BODY> <H1>500 SAP Internal Server Error</H1> ERROR: ([H_F1].[PARENTH1].&[ALL_FA],[H_ACCOUNT].[PARENTH1].&[KF_INT],[H_3RD_IC].[PARENTH1].&[TOTAL])+([H_F1].[PARENTH1].&[ALL_F],[H_ACCOUNT].[PARENTH1].&[B104],[H_3RD_IC].[PARENTH1].&[TOTAL])-([H_F1].[PARENTH1].&[ALL_FA],[H_AC cannot be interpreted as a number (termination: RABAX_STATE)<P> </BODY></HTML>

    I think that th "&" seems to be strange

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 13, 2017 at 04:02 PM

    Hi,

    Please have you resolved this problem?

    regards

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 16, 2017 at 07:55 AM

    Yes, it's resolved

    there was a comma between formula and solve issue

    [ACCOUNT].[AC_2500]-[ACCOUNT].[AC_2500_AT], SOLVE_ORDER=10

    and this caused the problem ....

    we had to change the formual to:

    [ACCOUNT].[AC_2500]-[ACCOUNT].[AC_2500_AT] SOLVE_ORDER=10

    That's it

    Add comment
    10|10000 characters needed characters exceeded