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: