Step 3 (As-Is) - Clean the raw performance history data
The performance history data files obtained here must be cleansed to ensure they are in the format expected by the data extract program. This should be done as follows.
- Run the Data Cleanser utility from the apps consumer interface.
- Use the Add Files button to add each of your performance history data files to the upload queue.
- Click Start Upload, and then download the clean file.
The clean file is in CSV format (with a .txt extension), and has the following columns:
- Program or Transaction Name
- Name of Background Job
- Description
- Usage Count
The data extract program uses data from the first and fourth columns (Program or Transaction Name and Usage Count).
Usage counts for each executable are aggregated so that each executable appears once only in the clean file. Embedded quotation marks and commas are removed from the first three columns, and values in the Usage Count column are formatted as numbers with no decimal separators.
Save the cleansed file to a temporary directory. If you plan to run the extract program using files from the SAP application server (for example, to run the data extract program as a background job), copy the cleansed file to a directory on the As-Is system that is accessible by SAPGUI.