How to use the RMF Spreadsheet Reporter

The Spreadsheet Reporter uses a resource oriented concept. Starting from the main dialog, you maintain the systems from which you retrieve the performance measurements, and the resources.

A typical usage scenario for the Spreadsheet Reporter is to run a Postprocessor job on the host, download the resulting Postprocessor data set (Report Listing or Overview Records) to the workstation, and convert it into a Working Set. The Working Set now contains your individual performance measurement data. Now you start a spreadsheet macro for graphical performance analysis and you feed the macro with the generated selected Working Set. This is the fast path for graphical presentation of RMF™ performance data.

As you can perform most of the transitions between the resource types in all variations, you may use the Spreadsheet Reporter also as a remote Postprocessor execution and download utility. For example, you may initiate the execution of a Postprocessor job from your workstation and store the Report Listing output on the host without downloading. Using File ---> Transfer, you can download RMF Postprocessor data sets later.

If you use the RMF Spreadsheet Reporter for the first time, you need to define one or more systems from which you want to retrieve performance measurements. If no system is defined, the Spreadsheet Reporter issues the following message:

If you do not want to define a system now, you can still continue to work with local resources. How to define systems is described in How to work with Systems.