Remote key validation

[Former Member]

Hi Experts,

I have mapped a field Customer number to Remote key in MDM system.For the records which are without customer no, remote key will be generated, but for records with Customer number, it will be directly created as new customer with same Customer number from the input file. Here the issue is, when loading records in MDM system via MDIS, some data have been worongly updated with customer number having ","  in the end. Now the requirement is to delete those records from MDM system, but we have more than 6000 records got updated. Since few data has comma and few are correct, i am feeling difficulty in identifying those records. Coz for checking itself i need to select and go to edit key mapping and see whether is it right data or not.

Can any one suggest me in creating a validation to this scenario for identifying records having comma "," in their remote key field.
Any other solution is warmly welcomed.

Thanks

vinoth

[Former Member · Accepted solution]

Hi Vinoth,

This happens accidentally and is nothing to be worried about.

Out of 101 ways to solve this the best is to export from Data Manager and import it via Import manager.

Steps can be -

1.Export MDMid,Customer id,remote system and remote key from Data Manager.It would be wise to filter data based on the time when the issue arise and now,so that volume of data on which we work will get reduced.

2.Connect the file with Import Manager.Map Customer id with Customer rid  -Here you click on Customer id.Map corrected Remote Key with Remote Key.You can also right click on Source remote key and set conversion filter as NORMALIZE to remove commas.Please note that do this mapping using correct Remote System.Import the data matching on Customer id and update action should be Update mapped.

3.Before you do an import please make sure you dont have automatic port ready to syndicate these updated records.You can either close those channels for sometime or set another filter in the map for blocking these updated entries.

In case you wish to remove wrong remote keys before correcting them please use this blog to help you do that -

http://scn.sap.com/community/mdm/netweaver-mdm/blog/2013/09/13/tricks-of-the-trade--quick-way-to-rem...

Thanks,

Ravi

[Former Member]

Hi Vinoth,

I dont think executing a validation on remote key would be possible rather i would suggest a different approach.

Syndicate these affected records to a flat file (including remote key values), then perform a validation check manually on this file(*.txt or *.xls) and delete comma from remote key field value. Then re-import these values through import manager and overwrite the remote key field with correct values. I think with this approach we can definitely overcome the issue.

Hope this helps ! Please let me know if any concerns.

Regards,

Ali

[Former Member]

Hi Mir,

This syndiication is not feasible, bcoz we have huge data in our repository. I need a solution to identify those records having comma in it rather than checking individual record.

Thanks

vinoth

[shanthi_kumar]

Hi Vinoth,

You can create an Expression which identifies the records having , in Customer Number. Add these records to a Mask. And from the mask you can syndicate the records and in the settings u can truncate the , from Customer Numbers.

Kind Regards,

Thamizharasi N

[Former Member]

Hi Thamil,

Can u please help me out in creating an expression, coz i don hav good idea in expressions.

thanks

Vinoth

[former_member193350]

Hi Vinoth,

For identifying "," in the Customer Number.

Just run the below expression:-

HAS_ANY_VALUES(Customer Number,",") It will pass through validation for those records which are having "," in customer number.

Kindly revert.

Regards

Prateek

[shanthi_kumar]

Hi Vinoth,

What Prateek has given will work. Please try out that. After filtering out the required records, goto Records (In the main Menu), Modify mask and add all the filtered records to the Mask and name the mask. Now in the Syndicator you can select the records in the mask and syndicate them according to your wish.

Hope this should solve your problem. Reply us with your result.

Kind Regards,

Thamizharasi N

[Former Member]

Hi,

The above expression will not work bcoz the field is mapped to remote key. i tried out and this did not work out.

thanks

vinoth

[shanthi_kumar]

Hi Vinoth,

I understand that Customer Number is a field in your Table. Hence you will be able to create an Expression. If it is not working go to Free Form search, in Customer Number select the operator contains and in Value give ",". The  values will be filtered out. From this u can save this as a local search and  and do the needful.

Kind Regards,

Thamizharasi N

[Former Member]

Hi,

I think its not a field in table rather its a remote key which will be seen under Edit key mappings section. As already said, i dont think assignment can be be executed for remote key. You  might need to try manual work around to overcome this.

Regards,

Ali

[shanthi_kumar]

Hi,

Yes, for remote keys we will not be able to create any validations. You will have to do it manually.

Kind Regards,

Thamizharasi N