on 05-27-2014 2:43 PM
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:
Sharing of any experience would be much appreciated,
Nick
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
6 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.