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

BPC Members Pre deletion.pngBW Members Pre deletion.png

Delete 4 members from BPC then process the dimension

BPC Members deletion 1.png

Only a single member is removed from BW

BW Members deletion 1.png

Refreshing the BPC dimension using UJA_REFRESH_DIM_CACHE results in the members reappearing in BPC.

BPC Members cache refresh.png

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.

BPC Members scenario 3.png

A new member DELTESt5 is added

BW Members scenario 3.png

Both DELTEST5 and DELTESt5 appear in the BW

To report this post you need to login first.

5 Comments

You must be Logged on to comment or reply to a post.

      1. Leila Lappin

        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

        (0) 
        1. Mark Sapey Post author

          Dear Leila and Roxane,

          Thanks for the tips, this issue seems to have been resolved by applying the note.

          Regards,

          Mark

          (0) 

Leave a Reply