Reports

This topic contains the following sections:

• SAP Data Services for Migrate

• Preparation of XML in Migrate

• Importing XML Code Into Data Services

• Post Import Maintenance of Project

• Mapping Standards

• Export Building and Execution

• Cross Reference Building and Execution

About Reports

There are three areas within a project for executing reporting (Transform, Target Readiness, and Postload). 

Transform - The reports are split into Remediation reports, Stage Ready reports, and Preload reports.

• Remediation reports query in Data Services contain all reports using remediation. The field values are updated after reports are generated.

• Stage Ready reports query in Data Services contain all reports in the Stage Validation report group including Stage Ready, Data Ready, and Info reports.  These reports are processed and the associated flags are updated as part of this process within queries (Data_Ready_Upd and Stage_Ready_Upd).

• Preload reports query in Data Services contains all reports related to the preload process.  These reports must process last to incorporate the remediated field values.

Target Readiness - The reports are grouped into one query in Data Services processes and a query updates flags for target readiness. 

Postload - The reports are grouped into one query in Data Services that processes after the Target table read-backs have completed.

Prerequisites for Running Reports in Data Services

• Generate/register reports in Syniti Migrate.

• Verify all created/registered reports are in SQL environment.

• Verify all created/registered reports are working properly.

• xAppMigrate datastore, and corresponding tables, need to be in local repository.

• xAppReport datastore is setup in local repository.

• xAppMigrate_WebService datastore is setup and contains the Report Token for ETL processing.

• All Reporting flags(ZREMEDIATED, ZSTAGE_READY, ZDATA_READY, ZBUSINESS_READY, ZCHUNK, ZTARGET_READY, ZERROR_LOG, ZINTARGETSYS, ZLOADED, and ZLOADDATE) should be on target table.

• Set up Parameters within Syniti Migrate for Working Database Type.  This is the client site database (Ex: HANA DB, Oracle, or SQL Server)

Parameters are set in the initial project setup phase, but if these values are changed it may cause issues for reporting.

Reports Processing

There are three workflows to process reports:

_010_Transform - _Transform_Rpts workflow. These should run at the end of the transform but prior to Export.

• Stage Ready_Rpts - Refreshes all stage ready reports, updates ZSTAGE_READY Flags. Also can update any ZERROR_LOG messages defined in the report details.

  • Remediate_Rpts - Updates any fields with values recorded as requiring remediation. Also updates the ZREMEDIATED flag on the target table.

• Data Ready - Refreshes all data ready reports, updates ZDATA_READY Flags. Also can update any ZERROR_LOG messages defined in the report details.

• Preload_Rpts - Refreshes all preload reports and counts.

Note

Refer to section Readiness Flags for Reporting and Remediation for details of the ready flags.

_500_TargetReadiness

Target Ready_Rpts - Refreshes all target ready reports and updates ZTARGET_READY flags. These are updated after dependent have loaded and read back from the target system. Refer to section Readiness Flags for Reporting and Remediation for details of this process.

Note

The Reports will update tables within the REPORT database for the report data stored as a static set of data.  The updates will mark all Target_Ready flags. 

_800_Postload

Postload Reports - Refreshes all postload reports. These are updated after data is loaded and read back from the target system.

Remediation Fields

Remediation can be turned on and off based on release by following the path Migrate > Project Setup from Syniti Migrate Homepage.

If remediation is toggled to active, then the field set within each report as remediation is updated for the remediated value as part of the Data Services job run.