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
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:
Sharing of any experience would be much appreciated,