Load PHD from ST03 Reports

This workflow allows performance history data downloaded from the SAP ST03N transaction to be uploaded to the PHD tab for an Analysis System. The workflow should be used in cases where an RFC connection to the Analysis system is not available from LiveCompare.

Prerequisites

Before running the Load PHD from ST03 Reports workflow, you will need to download performance history data from the Analysis System and store the data in several LiveCompare External Data Sources.

Download performance history data

The workflow uploads App, RFC and Web performance history data downloaded from the ST03N transaction.

Download app statistics

To download app performance history data from the Analysis System, follow these steps:

  1. Run transaction ST03N transaction on the Analysis system.

  2. In the Workload hierarchy, select the month for which to download App data.

  3. In the Analysis Views hierarchy, select Workflow > Transaction Profile > Standard.

  4. Select the All data tab and click Export tool button. to export the data to an Excel spreadsheet.

If you are downloading App data from more than one month, export the data for each month into separate Excel spreadsheet.

Download RFC statistics

To download RFC performance history data from the Analysis System, follow these steps:

  1. Run transaction ST03N transaction on the Analysis system.

  2. In the Workload hierarchy, select the month for which to download RFC data.

  3. In the Analysis Views hierarchy, select Workflow > RFC Profiles > RFC Server Profile.

  4. Select either the Function Module or Transactions tab (depending on the type of data you wish to download) and click Export tool button. to export the data to an Excel spreadsheet.

If you are downloading RFC data from more than one month, export the data for each month into separate Excel spreadsheet.

Download web statistics

To download web performance history data from the Analysis System, follow these steps:

  1. Run transaction ST03N on the Analysis system.

  2. In the Workload hierarchy, select the month for which to download RFC data.

  3. In the Analysis Views hierarchy, select Workflow > Web Statistics > WEB Server Statistics.

  4. Select the URL tab and click Export tool button. to export the data to an Excel spreadsheet.

If you are downloading Web data from more than one month, export the data for each month into separate Excel spreadsheet.

Create External Data Sources

  1. To create an External Data Source for an Excel file downloaded from the ST03N transaction, follow these steps:

  2. Select the Data > External Data Sources folder in the LiveCompare hierarchy and choose New External Data Source… from the context menu.

  3. Create an Excel External Data Source using a name that reflects the Analysis System, the type of data, and the month for which the data was downloaded, for example, ‘SAP56 App Stats 01-2023’.

  4. Upload the Excel file, check that the Worksheet field is set correctly, and click Save to create the External Data Source.

Repeat the above steps to create External Data Sources for each of the Excel files downloaded from the ST03N transaction.

Create an RFC Destination

In LiveCompare, create an RFC Destination for your Analysis system.

Prepare the workflow

To prepare the Load PHD from ST03 Reports workflow, drag its workflow template from the Templates > Tools folder into your own workspace. The following additional workflows will also be copied into the workspace:

Run the workflows

The workflows should be run in the following order, using the External Data Sources created for a particular month.

AppStats XDS to PHD

Run this workflow to verify that the App Stats External Data Source can be retrieved in LiveCompare.

  1. Set the External Data Source parameter to an App Stats External Data source created for a particular month (for example, ‘SAP56 App Stats 01-2025’).

  2. Set the RFC Destination parameter to the RFC Destination for your Analysis System.

  3. Run the workflow and review the contents of the Result dataset. The number of rows will typically be smaller than the number of rows in the External Data Source, because not all ST03 records will correspond to executable objects that LiveCompare recognizes.

Note: Since the ST03 report may have been created on an SAP system that uses a non-English locale, you may need to change the Name Field, Count Field, and Background Job Field String parameters to match the field names in the External Data Source.

WebStats XDS to PHD

Run this workflow to verify that the Web Stats External Data Source can be retrieved in LiveCompare.

  1. Set the External Data Source parameter to a Web External Data source created for the month used above (for example, ‘SAP56 Web Stats 01-2025’).

  2. Set the RFC Destination parameter to the RFC Destination for your Analysis System.

  3. Run the workflow and review the contents of the Result dataset. The number of rows will typically be smaller than the number of rows in the External Data Source, because not all ST03 records will correspond to executable objects that LiveCompare recognizes.

Note: Since the ST03 report may have been created on an SAP system that uses a non-English locale, you may need to change the Path/URL Field, and Count Field String parameters to match the field names in the External Data Source.

RfcStats XDS to PHD

Run this workflow to verify that the RFC Stats External Data Source can be retrieved in LiveCompare.

  1. Set the External Data Source parameter to an RFC External Data source created for the month used above (for example, ‘SAP56 RFC Stats 01-2025’).

  2. Set the RFC Destination parameter to the RFC Destination for your Analysis System.

  3. Run the workflow and review the contents of the Result dataset. The number of rows will typically be smaller than the number of rows in the External Data Source, because not all ST03 records will correspond to executable objects that LiveCompare recognizes.

Note: Since the ST03 report may have been created on an SAP system that uses a non-English locale, you may need to change the Name Field and Count Field String parameters to match the field names in the External Data Source.

Load PHD from ST03 Reports

This workflow combines the App, Web and RFC Performance history data, and uploads it into the PHD tab for your analysis system. To run the workflow, follow these steps:

  1. If this is the first time you are running this workflow for a particular Analysis System, select the Analysis System in the Administration > RFC Destinations folder, and in its PHD tab, click Delete Cache.

  2. Open the workflow and set a value for the Analysis System RFC Destination parameter.

  3. Set values for the App Stats XDS, Web Stats XDS and RFC Stats XDS External Data Source parameters. These External Data Sources should include performance history data downloaded for the same month.

  4. Run the workflow and then check the Analysis System’s PHD tab. It should include an additional month’s worth of data.

Repeat the steps in the Run the workflows section to upload ST03 reports for additional months.

Notes

  • The PERIOD (date information) in the performance history data database is arbitrarily set to the first day of the month previous to when the workflow is run. For example, if you ran the workflow on 2023-01-31, the performance history data database’s PERIOD value is 20230101.

  • The Users Statistics data in the performance history data database is a copy of what's in the Application Statistics with the ACCOUNT field set to UNKNOWN. This is done so that the Smart Impact app (or any other app or workflow) that depends on having users statistics will run without error.