Example 1: Creating a simple chart

 

As a first example we want to create a simple chart from a CSVREPnn file. The graphic below only shows the center part which is most important for the chart generation:

The new chart will be created for CSVREP01. The data sheet which is used is always shown in the top  of the chart definition screen. If multiple CSV data sheets are contained in the workbook you can either change the sheet which is used for charting on the OpenRep worksheet or via the “Load New Report” on the main worksheet.

The data sheet is created from SMF 99 subtype 2 records and contains performance information for service class periods. We want to plot the ended transaction rate and corresponding response time on the chart and use the Time as X-Axis value. For this reason we enter column number 3 for the X-axis and column number 67 (response time) and column 99 (ended transaction rate). Response time and ended transaction rate have very different scales. Therefore we want to plot the transaction rate on the Y2-axis on the new chart and enter a 2 for “Y-Axis 2” under the “Which Y-Axis” column.

The next step is to give the new chart a name “Trx”, a title “Ended Transactions and Response Time”, and to provide descriptions for the Y and Y2 axes. Finally we select the “Chart Type . We want to create a line chart in this example and we select some options:

Then we press “Create Chart”  to create our new chart. When we select the chart tab with the name “Chart_Trxn” with n being the current sequence number we see the following:


 

 

The chart looks basically unreadable! The reason is that the data table contains many service class periods and for each time period multiple different service class periods are reported.

 

 

 

 

 

 

 


 

 

In order to make the chart readable we switch to the CSVREP01 data sheet and filter the data sheet by service class and we want to take a look at the CICSPROD service class. The service class is printed in column 5 or E in this example.

After doing this the chart looks meaningful and plots the ended transaction rate and response time for service class CICSPROD. If we want to examine a different service class we can switch back to the CSVREP and change the filtering criteria.

Finally we want to take a look how the chart would look like if we create it with our own colors. For this reason we recreate the chart but we switch off the “Default” color option: . After pressing “Create Chart” again we get the same chart with a blue line (index 5) for transaction completions and an orange line (index 46) for transaction response time: