Skip to Content

Overview

               MDG has come up with a Data Quality Remediation Toll which can act as an interface to display some data quality related records from 3rd party systems. This tool itself does not do the data quality check but acts just like an interface through which you will be able to create Change request.

Configuration

             Go to transaction code MDGIMG where you will be able to assign a class for DQR interface.

/wp-content/uploads/2013/02/145_181934.jpg

Provide the following values. The class you provide should have the interface IF_MDG_DQR_DQ_SERVICE implemented in it.

/wp-content/uploads/2013/02/145_181934.jpg

Create a new business Activity with following logical action which is already provided.

/wp-content/uploads/2013/02/145_181934.jpg

Create Corresponding change Request types and workflow for this Busines Activity.

This is the ebdynpro Component which has to be called for the DQR

MDG_DQR_OVP

You can add this to your role so that you can access it from NWBC

/wp-content/uploads/2013/02/145_181934.jpg

Custom Class for Data retrieval

Implement the method IF_MDG_DQR_DQ_SERVICE~GET_FAILED_RECORDS to fetch records from 3rd party system or your Data Quality tool and display it to the DQR interface.

Sample coding:

data:
              gv_rfc           type rfcdest value ‘xxxxx’,
              gv_msg           type c length 255.

        field-symbols:
          <gs_rec>     like line of lt_error_records.

        call function ‘xxxxxxx’
          destination gv_rfc
          importing
            et_matnr_errors       = lt_error_records
          exceptions
            system_failure        = message gv_msg
            communication_failure = message gv_msg.

     

Implement method IF_MDG_DQR_DQ_SERVICE~GET_FILTER_CRITERIA for setting up of your own filter criteria.

Implement method IF_MDG_DQR_DQ_SERVICE~SET_DQS_ID to set your DQR ID which you provided in the configuration

Implement method IF_MDG_DQR_DQ_SERVICE~GET_CREQUEST_ATTRIBUTES to fill in the Change request attributes.

This is the place where change request Description is filled.

Execution

Once all the configurations and coding are done, based on the filter criteria, the values will be retrieved from the RFC.

/wp-content/uploads/2013/02/145_181934.jpg

If there is a Change request assigned to one of your records, then the change request is automatically displayed or else you could select the row and Click Change request which will immediately create a Change request of the type which you have configured to Business Activity CHANGE_DQR. If there are more than 1 change request then a pop up comes up to select the required change request type. You could also do a multiple selection and Create a mass Change request or even create individuval change request for all the items based on your configuraion

/wp-content/uploads/2013/02/145_181934.jpg

To report this post you need to login first.

3 Comments

You must be Logged on to comment or reply to a post.

  1. Former Member

    Dear Alex,

    Could you please upload the screen shots which are of better quality. Also if you could throw some light on the RFC, If I want to connect to the failed record database of my Information steward which is installed in my laptop.

    Any kind of help/information would be deeply appreciated.

    Regards,

    Tushar.

    (0) 
    1. Former Member Post author

      Hi Tushar,

           for some reason, the images are getting uploaded in the same way, in this blog even though I have high quality images.

      —regards,

         Alex B Justin

      (0) 

Leave a Reply