Transformation example
The following example shows how to use the transformation to map data from the Purchase Requisition Item and Purchase Order Item extractions to the Create purchase requisition item and Create purchase order item activities and create a unique activity table and dimensional tables. The example is based on the Purchase to Pay example.
ARIS Process Mining requires a single activity table containing all relevant source data as a basis for further processing of the data. The SAP source system does not provide for the extraction of a single activity table. After the extractions of the SAP source data, the data is stored in separate tables. These tables must be transformed into a format that can be processed by ARIS Process Mining.
The goal of the transformation is to create a single, comprehensive activity table based on all extracted source tables. The activity table contains all relevant columns, where each row represents an individual activity. In addition, you need other data that you can evaluate in your analyses, such as throughput times or costs. For this, you can create dimension tables that contains the relevant data.
You must create two transformations for each extraction. The first transformation statement creates an activity table and the second creates a dimension table for the respective activities.
In the last step, you need to merge the activity tables of the two extractions into a single activity table.
Purchase Requisition Item extraction
Purchase Order Item extraction
Finally, merge the different activity tables into a single activity table.
Using the created tables, you must create a data model that forms the basis for the following process analyses.