Data Governance in Process Runner
Data Governance in Process Runner |
|
|
The Data Governance feature allows user to centrally store validation rules for the data in the Innowera Control Panel (ICP). These rules can then be assigned to elements at the process file level through the Dynamic Skip option 'Y - Data Governance Rule' in the Mapper.The Rules are executed at run time by Process Runner providing capability of centralized Data Governance and validating the specific data field with the values stored in database or SAP table/view.
Let us use the example “MM02 – Change Material” process file. The user requires validation of the "Gross weight" present in process file. In this scenario, the user will apply validation rule on the Gross weight field. The validation rule written in VB .Net code in Innowera Control Panel will ensure that the Gross weight doesnot exceed a particular value.
We will take a step by step look at how centralized data governance is implemented in Process Runner.
1.Open the process file from the desired system location or from Start Page grid which displays recently opened process files. 2.Select the Mapper tab. 3.Select the element of transaction (Gross weight field) and click on 'Dynamic Skip' field. 4.Select ‘Y- Data Governance Rule’ option from the Dynamic Skip drop down list.
5.System pops up ‘Data Governance Rule’ window. Select the Rule that is configured in Innowera Control Panel from ‘Rule ID’ drop down list. System automatically shows the ‘Rule Name’ and ‘Rule Description’.
6.Click the ‘OK’ button. 7.Click on 'Validate Data Governance Rule' to validate the data of process file. Please note that this will not post the data into SAP.
This option is also available under 'Actions' menu. This is available only for Transactions.
8.In Confirm window click on 'Yes' button.
When set to execute, click on 'Run' button in the toolbar. The Gross weight data in process file will be validated against the GrossWeight rule stored in the ICP, if the data is valid it will pass through the transaction, if not valid will return error message that has been designed in rule. If in the future rule changes it can be updated directly in the ICP and nothing would be changed at the process file level.
Note:
1.Data Governance is available for GUI Scripts under Mapper tab > Dynamic Skip column. 2.Data Governance Rule is also available for Data Extractor. Please refer Dynamic Skip in Data Extractor for detailed steps. 3.System shows all rules configured in ICP in the ‘Data Governance Rule’ window. 4.In Innowera Control Panel if the Process Runner row address is written in where condition or custom filter then that rule will be complied and executed for each and every row of the process file.This may have an impact on the performance
5.If user chooses Inactive rule, message indicating that the given rule id is inactive in Control Panel is displayed. On clicking OK button, error is displayed in Process Runner.
6.Error is displayed if license is not present for Data Governance in Innowera Control Panel and user chooses 'Y- Data Governance Rule' option.
7.User can configure multiple rules for a single process file on different elements of transaction. However, system does not permit to configure more than one rule for a single element of transaction.
8.Error is displayed if Query for the selected rule is not defined in Control Panel.
9.Data validation with Database: Storing validation data and/or rules in a database which is then connected through Control Panel. When setting data validation rule, query will be made to database table and used to compare against data being uploaded.
10. Data validation with SAP Live Query: Live Query allows validation against live SAP data by querying SAP tables directly. Using Live Query will allow organizations to check the existence or non-existence of data before making upload call to SAP. By using Live Query you will always have access to real-time data.
Next: |
