SAP HANA Migration Assessment Summary Excel Report
The SAP HANA Migration Assessment Summary Excel report provides a summary of the upgrade tasks in each of the Development, Testing, Integration, Security and Training areas. It also provides an estimate of the time required to perform each task, based upon the Program Evaluation and Review Technique (PERT). The report includes the following spreadsheets.
Dashboard
The Dashboard spreadsheet includes the following charts.
- The # of Objects column chart summarizes the number of objects that require attention in each of the upgrade areas.
- The Effort (Days) column chart summarizes the number of days’ effort required to complete the tasks in each of the upgrade areas. These values are calculated in the D1 (hidden) spreadsheet.
-
The Elapsed (Days) column chart summarizes the number of days’ effort required to complete the tasks in each of the upgrade areas, given the available resources set in the Resources spreadsheet. These values are calculated in the D1 (hidden) spreadsheet.
- The Resources column chart summarizes the number of full-time employees assigned to the project in each of the upgrade areas. These values may be set in the Resources spreadsheet.
Scope of Work
The Scope of Work spreadsheet lists the tasks identified for the upgrade, grouped into the Development, Testing, Integration, Security and Training upgrade areas. For each task, the Errors column lists the number of objects which may result in an error following the upgrade, and the Warning column lists the number of objects for which a warning condition has been identified.
Development
This area includes the following types:
SPAU/SPDD
The SPDD/SPAU type summarizes the impacted SPAU and SPDD objects. These are classed as Error items.
Code Correction
The Code Correction type includes tasks relating to impacted code. Impacted custom code and Smart Forms are classed as Error items. Impacted BDC Interfaces are classed as Warning items.
HANA
The HANA type summarizes rule violations in the HANA ABAP Quality Rule category. Rule violations in the ‘Error’ class are listed as Error items. Rule violations in the ‘Warning’ class are listed as Warning items.
Code Cleanup
The Code Cleanup type summarizes rule violations in ABAP Quality Rule categories other than the HANA category. Rule violations in the ‘Error’ class are listed as Error items, and rule violations in the ‘Warning’ class are listed as Warning items. For the Complexity task, code objects identified as ‘Bad’ are listed as Warning items, and code objects identified as ‘Ugly’ are classed as Error items.
Testing
This area includes the following types:
Impacted Custom Code
Impacted custom code objects are classes as Error items.
Impacted Standard Code
Impacted standard code objects are classed as Error items.
BDC Interfaces
Impacted BDC Interfaces are classed as Error items.
Integration
This area includes the following types:
Custom IDOCs
Impacted custom IDOCs are classed as Error items. These are custom IDOCs with differences in their segments on the As-Is and To-Be systems, and custom IDOCs with segments that have been added or deleted on the To-Be system.
Standard IDOCs
Impacted standard IDOCs are classed as Error items. These are standard IDOCs with differences in their segments on the As-Is and To-Be systems, and standard IDOCs with segments that have been added or deleted on the To-Be system.
Security
This area includes the following type:
Profiles
Profiles with added or deleted authorizations on the To-Be system are classed as Error items.
Training
This area includes the following types:
Impacted Custom
Impacted custom objects are classed as Error items.
Impacted Standard
Impacted standard objects are classed as Error items.
Used Obsolete
Used obsolete transactions are classed as Error items.
SoW Data
The SoW Data spreadsheet contains the raw data used in the Dashboard and Scope of Work spreadsheets. It lists the number of errors and warnings identified for each upgrade task.
PERT
The SAP HANA Migration Assessment Summary Excel Report uses the Program Evaluation and Review Technique (PERT) to provide an estimate of the number of days required for each upgrade task. The PERT spreadsheet contains Optimistic, Pessimistic and Typical estimates for the number of objects that may be reviewed in one day. These values may be adjusted as required. From these estimates, a PERT value is calculated for each upgrade area as follows:
PERT Value = (O + 4T + P) / 6
Resources
The Resources spreadsheet allows you to specify how many full-time employees are assigned to each of the upgrade areas. These values are displayed in the Dashboard spreadsheet’s Resources chart.
Help
This spreadsheet includes help for each of the spreadsheets in the SAP HANA Migration Assessment Summary Excel report.
D1 (hidden)
The D1 (hidden) spreadsheet lists the number of objects that require attention in each of the upgrade areas. The number of days’ effort required for each of the upgrade areas is calculated as follows:
Effort (Days) = # of Objects / PERT Value
These values are displayed in the Dashboard spreadsheet’s Effort (Days) chart.
The Elapsed (Days) column for each of the upgrade areas is calculated as follows:
Elapsed (Days) = Effort (Days) / Resources assigned to this upgrade area.
System Info
This spreadsheet describes the As-Is and To-Be systems used in the analysis.