Issue deleting multiple members from a dimension – BPC 10.1 NW SP5
Warning : only delete a single member before processing a dimension using BPC 10.1 Standard (NetWeaver) SP5
Only a single record in the BW table is deleted when deleting multiple dimension members through the BPC dimension admin.
We have managed to resolve this issue by applying note 2164233.
I have tested this at 3 different customer installations of BPC. This has been raised as a message with SAP, but I thought it worth sharing.
Scenario 1: Delete multiple members of a dimension through the BPC dimension maintenance.
7 members have been added to a dummy dimension
Starting position – members appear OK in both BPC and BW
Delete 4 members from BPC then process the dimension
Only a single member is removed from BW
Refreshing the BPC dimension using UJA_REFRESH_DIM_CACHE results in the members reappearing in BPC.
Scenario 2: Reuse a member ID but with a different case.
DELTEST5 has been previously deleted as a part of a multi delete and had been left in the BW database.
A new member DELTESt5 is added
Both DELTEST5 and DELTESt5 appear in the BW
Please see SAP Note 2164233 - Only the last member is deleted from Admin
Hi Roxane,
Thanks for the tip.
However this note is for BPC 10.0 not 10.1.
Regards,
Mark
Hi Mark,
This is good information and thank you for sharing it. I just checked the note 2164233 and it seems that it has been up-ported for BPC 10.1.
I found this in the Support Packages section of the note: CPMBPC 810 SAPK-81007INCPMBPC
Dear Leila and Roxane,
Thanks for the tips, this issue seems to have been resolved by applying the note.
Regards,
Mark
Hi Mark,
That is great news, could you please mark the question as answered, thank you
Regards,
Leila