Skip to Content
0

SAP BPC Member Formulas error

Mar 13, 2017 at 04:21 PM

80

avatar image

Hi folks ,

I'm facing a problem with SAP BPC 10.1.

we upgraded our system to SP06.

now we are facing a problem .

I have duplicate member ID aftrer processing the dimension , I can't delete them.

what do you suggest?

system.png (29.2 kB)
error.png (12.1 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Vadim Kalinin Mar 13, 2017 at 05:18 PM
0

Look on this note: https://launchpad.support.sap.com/#/notes/2338935/E

Search notes for: bpc duplicated member ID

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

Hi Vadim,

we just upgraded our system to the last version.

I tried to implemente all notes about duplicate member ID while processing bu they are can't be implemented .

Regards

notes.png (7.9 kB)
0
Fatima zahra El Amrani

Can you show full formula text?

Can you delete this formula?

1

Hi Vadim ,

When I run the program UJA_REFRESH_DIM_CACHE . the duplicated member is deleted, and then after when I recreate it the member and the formula , the member formula is duplicated again and then after rexecuting the UJA_REFRESH_DIM_CACHE I'm not having duplicated members problem solved but I shoud do that after creating every formula.

0

I can't delete the formula.

the formula text is :([TV_BESOIN_SEM].[BS025]+[TV_BESOIN_SEM].[BS026]-[TV_BESOIN_SEM].[BS027]+[TV_BESOIN_SEM].[BS028])/[TV_BESOIN_SEM].[BS002]

TV_BESOIN_SEM is an account dimension

0
Fatima zahra El Amrani

If "TV_BESOIN_SEM is an account dimension" then you can use:

([BS025]+[BS026]-[BS027]+[BS028])/[BS002]

you don't need full member name for account dimension

0
Vadim Kalinin Mar 14, 2017 at 12:37 PM
0
Show 6 Share
10 |10000 characters needed characters left characters exceeded

all theese notes can't be implemented in the system.

I already tried to apply all of them.

regards.

0
Fatima zahra El Amrani

Can you show your kernel info screenshot?

GUI: Menu: System -> Status... -> Shift+F5

0

here is the screenshot.

kernel.png (24.1 kB)
0
Fatima zahra El Amrani

And in the kernel note the patch (2404956) for 749 is: SP111

1

Hi Vadim ,

why I can't find the SAPEXE patch in the link of the note ,I founf sapkpropt_111 . I put the files in NTTAMD64, but rhe patch level isn't upgraded , BC team told that i should find the SAPEXE file ? what do you think?

kernel.png (15.8 kB)
0
Fatima zahra El Amrani

Sorry, but no idea! May be contact SAP support...

1