Skip to Content
0

SAP BPC Member Formulas - duplicate member ID

Feb 24, 2017 at 08:47 AM

567

avatar image
Former Member

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
avatar image
Former Member 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
avatar image
Former Member 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
avatar image
Former Member 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
avatar image
Former Member 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
avatar image
Former Member Feb 24, 2017 at 12:44 PM
0

yes, that's true ...

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member 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
avatar image
Former Member 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
avatar image
Former Member 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
Former Member

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