In the tramsform phase the app MPM_Process_02_Transformed is employed. In this phase, the .qvd-files from the first phase are transformed. If you already extracted modified tables with a connector (i.e. SAP connector) you can store them through this app. New keys can be created here and data views as well. A data view is a join of tables that are several times re-used in the third app MPM_Process_03_ProcessLog.

 

As you know, an event log needs timestamps for each activity. If there is need to create a timestamp from two different fields (a date and a time-field) then make these changes in the tables in this step.

 

 

 

Example

 

Continuing with the previous example, the tables CDHDR, CDPOS and RSEG need to be combined to one data view table to derive an event (see figure below). As the tables CDHDR and CDPOS are used multiple times for different purpose, the join of these two tables is performed in the “MPM_TypeProcess_02_Transform” App. As these tables store lots of different table information, we already reduce their size to the purchase orders information in the first phase (where statement OBJECTCLASS=’EINKBELEG’) which reduces the size of the tables and, thus, improve their performance. The timestamps are also formatted here for the correct execution of the mining algorithms. We obtain the timestamp AETST from the CDHDR table by combining the UDATE with UTIME as done below:

 

•AETST = timestamp(date(date#(CDHDR_UDATE,'YYYYMMDD')) +  time(time#(CDHDR_UTIME,'hhmmss')))

 

To connect the tables, the following keys are used:

•%CDHDR_PKEY: [MANDANT] & '_' & [OBJECTCLAS] & '_' & [OBJECTID] & '_' & [CHANGENR]

•%EKKO_PKEY:  mid(TABKEY, 1, 3) & '_' &  mid(TABKEY, 4, 10)

 

Example CDHDR_CDPOS view creation

 

CDHDR_CDPOS_EINKBELEG:

LOAD *,

     [CDPOS_MANDANT] & '_' & [CDPOS_OBJECTCLAS] & '_' & [CDPOS_OBJECTID] & '_' & [CDPOS_CHANGENR] as [%CDHDR_PKEY]

FROM [$(DataConnection)/ProcessAnalyzer_$(mvProcessDescription)/01_Extract/transformed/CDPOS_EINKBELEG.qvd]

(qvd);

 

inner join(CDHDR_CDPOS_EINKBELEG)

LOAD *,

     [CDHDR_MANDANT] & '_' & [CDHDR_OBJECTCLAS] & '_' & [CDHDR_OBJECTID] & '_' & [CDHDR_CHANGENR] as [%CDHDR_PKEY],

     timestamp(date(date#(CDHDR_UDATE,'YYYYMMDD')) + time(time#(CDHDR_UTIME,'hhmmss'))) as CDHDR_AETST

FROM [$(DataConnection)/ProcessAnalyzer_$(mvProcessDescription)/01_Extract/transformed/CDHDR_EINKBELEG.qvd](qvd)

where timestamp(date(date#(CDHDR_UDATE,'YYYYMMDD')) + time(time#(CDHDR_UTIME,'hhmmss'))) > '$(mvDateFilter)';

 

store CDHDR_CDPOS_EINKBELEG into [$(DataConnection)/ProcessAnalyzer_$(mvProcessDescription)/02_Transform/views/CDHDR_CDPOS_EINKBELEG.qvd] (qvd);

drop table CDHDR_CDPOS_EINKBELEG;