Skip to Content
0

SAP BPC Member Formulas - duplicate member ID

Feb 24, 2017 at 08:47 AM

527

avatar image

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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

10 Answers

Vadim Kalinin Feb 24, 2017 at 09:15 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Christian Sass Feb 24, 2017 at 09:56 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Christian Sass Feb 24, 2017 at 10:15 AM
0

Hi,

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

pic-1.png


pic-1.png (9.2 kB)
Share
10 |10000 characters needed characters left characters exceeded
Vadim Kalinin Feb 24, 2017 at 10:54 AM
0

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

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

Share
10 |10000 characters needed characters left characters exceeded
Christian Sass Feb 24, 2017 at 11:03 AM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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

Hope it will help! Strange bug

0
Christian Sass Feb 24, 2017 at 11:07 AM
0

this one looks good

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

but we are already on sp16

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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

0
Christian Sass Feb 24, 2017 at 12:44 PM
0

yes, that's true ...

Share
10 |10000 characters needed characters left characters exceeded
Christian Sass Feb 24, 2017 at 01:15 PM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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

0
Fatima zahra El Amrani Mar 13, 2017 at 04:02 PM
0

Hi,

Please have you resolved this problem?

regards

Share
10 |10000 characters needed characters left characters exceeded
Christian Sass May 16, 2017 at 07:55 AM
0

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

Show 3 Share
10 |10000 characters needed characters left characters exceeded

You can simply remove

SOLVE_ORDER=10

0

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

Thx

0

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!

0