cancel
Showing results for 
Search instead for 
Did you mean: 

How duplicate BW master ID's be handled in BPC 10 NW?

Former Member
0 Kudos

Hi,

We are importing master data from BW for a dimension that has an issue with duplicate records. The reason stems from our master data source being less regulated upon creation, thus somewhat duplicate records existing.

The example below shows two different ID's:

DINE ALONE           and

DINE_ALONE

To create these as ID's in BPC, we have a standard special character handling conversion script that will replace spaces with '_'.

This results in a duplication error - as two members exist with the same ID - DINE_ALONE.

I can see a few options here but would like to see if anyone has any other suggestions on handling this.

I have identified that we could:

  • Request the business clean up the master data (time consuming and unlikely to happen in our time frames)
  • Manually maintain the master data in BPC only (time consuming for on-going support)
  • Use another character to separate (this won't work in all scenarios, some differ by special character on the end, e.g. '/' which when removed will result in the same ID (as above, VVS_FILMS and VVS_FILMS since / is removed
  • Use an END_ROUTINE ABAP script to remove duplicates and special characters
  • Configure BPC to handle duplicates - I'm unaware of any standard functionality to do this so this is where I need your validation!

Sharing of any experience would be much appreciated,

Nick

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member200327
Active Contributor
0 Kudos

Hi Nick,

Main question here is: does business want to keep those members as separate members or it wants to merge them.

If they want to keep them as separate then you have to come up with a better conversion procedure.

If they want to merge them then you have to find out how to find another member to merge with.

You should also implement same procedure when you are going to load Transaction data.

Gersh

Former Member
0 Kudos

Hi Nick,

My suggestion would be ask the business to clean up the data first, if they need to use those duplicates then you need to replace the symbols with longer _ or even numbers, so that it will make them unique, in case you need to retract data back into BW.

As far as I know, BPC doesn't accept duplicates, there is no option for you to set.

I think the standard conversion file should handle the conversion easily, no need for BADI.

Andy