on 02-24-2017 8:47 AM
Hi Community,
we've updated BPC to
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?
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Please have you resolved this problem?
regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Not strange, please read about MDX: https://msdn.microsoft.com/en-us/library/ms145495.aspx
yes, that's true ...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Please search notes for: "BPC Member Formulas duplicate member ID"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Vadim,
I've copied ENVIRONMENTSHEL and I've the same problem
It appears even without
At the beginning I thought it's a problem of the HANA Acceleration but it might be something else ...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Start with tests on ENVIRONMENTSHEL copy... Create single simple formula...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
6 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.