Before you export the output data set to use it in AppOne it is advised that you check if the data from the input data files is properly connected in the SAP Order-To-Cash Connector. The SAP Order-To-Cash Connector contains pre-defined dashboards to validate the data.
Connecting your database ends with validating if all necessary data is available and in the right format. The Data validation menu contains dashboards validate if all necessary data is available and in the right format.
The Data validation - Invariants dashboard provides multiple checks. See illustration below for an example.
In case a check fails, the invariant is marked in bold and black letters. In case no input data is available, the result will be
-, otherwise the result is
false. To check what the issue is, search the name of the issue in the table list on the left of the HTML panel. Each invariant may contain one or more checks. You can open the corresponding invariant to check why a check fails.
Input checks check all key field attributes for the following properties:
- The field contains values;
- The field does not contain
- The field has a specified length (where possible).
Document graph checks check if all documents are unique within the case.
The output checks check the output of the connector:
- The Case ID is unique and exists;
- The Activity is defined;
- The Event end is defined.
Next to the Invariants dashboard, the following dashboards are available to analyze the different sub-processes:
- Sales document;
These dashboards contain information on the number of records loaded from the different tables. This enables you to check the number of records. Furthermore the amount of headers and items that are excluded are reported.
The Output menu in the SAP Order-To-Cash Connector contains dashboards to check the output data for use in AppOne.
The numbers on the top right in the Cases output and Events output tabs show how many cases and events there are in the input and output.
You can also use the Process graph dashboard to check if the data is properly connected.