U.04 - User Location Analysis

This workflow reports on the user location details for a system’s used programs or transactions. The results are stored in a Dashboard report that provides data for the Upgrade Analysis Dashboard report.

Creating RFC Destinations

Before you begin, you will need to create RFC Destinations for each of the SAP systems you wish to compare, and for the system from which to retrieve performance history data.

In the LiveCompare hierarchy, select the RFC Destination from which to retrieve performance history data, and click the PHD tab. Enter a value (n) in the ‘Keep this many months of data:’ field, and click ‘Update Data’ to download the most recent <n> months of performance history data. You may also specify a schedule so that the available performance history data is downloaded at regular intervals. See the Retrieving Performance History Data help topic for details.

The Prepare Object Links Cache workflow from the Upgrade package should be run before the U.04 - User Location Analysis workflow is run against an RFC Destination for the first time, or to update the RFC Destination’s object links database after new support packs or transports have been applied.

Preparing the Workflow

To prepare the User Location Analysis workflow, drag its workflow template from the Templates folder into your own workspace, and modify the workflow as follows:

To specify the Current or As-Is system:

  1. Select the System 1 parameter and choose ‘Edit RFC Destination’ from its context menu to display the RFC Destination dialog.

  2. Select the RFC Destination for the system to analyze, then click ‘Save’.

To specify the system from which to retrieve performance history data:

  1. Select the System 3 parameter and choose ‘Edit RFC Destination’ from its context menu to display the RFC Destination dialog.

  2. Select the appropriate RFC Destination, then click ‘Save’.

Save the workflow using the ‘Save’ toolbar button.

Running the Workflow

To run the U.04 - User Location Analysis workflow, click the 'Run' toolbar button, choose ‘Run Now’ from the diagram’s context menu, or press F5. The currently running workflow action is marked with an animated display. When the workflow execution has completed, select the Report URL dataset and choose ‘View Details’ from the context menu to display the associated Dashboard report. This URL is returned to the Run Complete Analysis workflow, and provides data for the Upgrade Analysis Dashboard report.

Dashboard Report

The Dashboard report generated by U.04 - User Location Analysis workflow includes a pie chart showing the top N user transactions by SAP user account. The value for N is set in the workflow’s Number of categories String parameter.

Additional Resources

The Additional Resources section of the Dashboard report includes links to the following report:

U04 - User Location Analysis

This Excel report includes the following spreadsheets:

Common Transactions by Account

This spreadsheet lists the number of user accounts that have run each transaction, according to the retrieved performance history data.

Accounts by City

This spreadsheet lists the number of user accounts in each city, according to the retrieved location data.

Unique Transactions by Account

This spreadsheet lists the number of unique transactions executed by each user account, according to the retrieved performance history data.

Usage Data

This spreadsheet lists the transactions executed by each user according to the retrieved performance history data. It also shows each user’s location details.

Analysis Input Data

This Excel report contains a copy of the input parameters used to produce the App’s Dashboard report. The value of each input parameter is stored in a separate worksheet, which is named after the parameter whose value it contains.