cancel
Showing results for 
Search instead for 
Did you mean: 

SAP BPC Member Formulas - duplicate member ID

ChristianSass
Participant
0 Kudos

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?

Accepted Solutions (0)

Answers (10)

Answers (10)

ChristianSass
Participant
0 Kudos

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

former_member186338
Active Contributor
0 Kudos

You can simply remove

SOLVE_ORDER=10

ChristianSass
Participant
0 Kudos

Is SOLVE_ORDER=10 the standard order? and that's why I don't need to mention it?

Thx

former_member186338
Active Contributor
0 Kudos

SOLVE_ORDER is required for complex combinations of dimension member formulas in different dimensions. For simple case with single account dimension you don't need it!

former_member269849
Participant
0 Kudos

Hi,

Please have you resolved this problem?

regards

ChristianSass
Participant
0 Kudos

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

former_member186338
Active Contributor
0 Kudos

Not strange, please read about MDX: https://msdn.microsoft.com/en-us/library/ms145495.aspx

ChristianSass
Participant
0 Kudos

yes, that's true ...

ChristianSass
Participant
0 Kudos

this one looks good

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

but we are already on sp16

former_member186338
Active Contributor
0 Kudos

But this note is about member formulas and related to Embedded model...

ChristianSass
Participant
0 Kudos

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

former_member186338
Active Contributor
0 Kudos

Yes, looks like! I see the only way - contact SAP support and provide the access to your system...

Hope it will help! Strange bug

former_member186338
Active Contributor
0 Kudos

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

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

ChristianSass
Participant
0 Kudos

Hi,

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

pic-1.png

ChristianSass
Participant
0 Kudos

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 ...

former_member186338
Active Contributor
0 Kudos

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