cancel
Showing results for 
Search instead for 
Did you mean: 

MDM Issues -ii-

former_member283645
Participant
0 Kudos

Hello experts,

when a validation fails - Error message pops up.

Now, what should we do with the records that failed at validation?

Will they be automatically Deleted from table??

or

Should we need to change the data(then and there) and run the validation again??

If my client requirment is to delete the records which did not meet the validation, is there any way otherthan manually selecting and deleting them??

Can we validate the data before it falls in to the mdm database??If so How?

Kind Regards

Eva

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

HI Eva

Automatic deletion of records which has failed validations is not possible in MDM.

Validations are defined to ensure that records in MDM are meeting data quality checks and prurpose should be more on correcting the records so that they are in lines with the Data governance principles laid down in MDM repository.

Can we validate the data before it falls in to the mdm database??If so How?

Design a workflow W1 like Start(checkout)-> Validate-> process(mark for deletion)-> Stop(check in)

Next trigger this workflow as part of the import process. Each record imported will be assigned to w1 and will be checkedout. If the record is failing the validation in the next step User can mark the records with deletion flag(define this field in Data model).

All such records can be searched and deleted from MDM.

best regards

Ravi

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Eva,

It is not possible in SAP MDM to delete a record automatically if it fails Validation. we can manually correct the value after validation fail or we can delete it manually.

To identify the new record which fails validation,we have to do it with workflow as mentioned abve by other people.

Regards,

Bis

Former Member
0 Kudos

Hi,

No, record would not be automatically deleted if it fails the validation.

We cannot restrict the record from being imported in MDM but we can launch the workflow on record import which will put the record in CheckedOut mode unless it has been changed to adapt the validation criteria.

Regards,

Jitesh Talreja