3. Reports and Graphics › 3.2 Printed Reports › 3.2.5 Tabular Ranking Report

3.2.5 Tabular Ranking Report

 +--------------------------------------------------------------------------+
 |       Prime Shift TSO User Ranking - Top 4 Users By Command Count        |
 |                                                                          |
 |                Development TSO System,  November 29, 1988                |
 |--------------------------------------------------------------------------|
 |             |         | Average Resp.| Pct. Short | Pct. Long  |         |
 |     Time    |         | Time (sec.)  |   Within   |   Within   | Command |
 |    Period   | USERID  | Total  Short | 0.50  0.80 | 0.80  1.00 |  Count  |
 |-------------+---------+--------------+------------+------------+---------|
 | 14:00-15:00 | APPL035 |  1.34   0.41 | 95.2  99.3 | 94.6  98.2 |     542 |
 |             | SYSUSR9 |  1.78   0.50 | 85.7  99.1 | 92.9  96.1 |     489 |
 |   235 Users | APPL286 |  1.21   0.35 | 93.5  99.4 | 89.4  94.5 |     342 |
 | In Interval | APPL876 |  2.45   0.80 | 85.1  94.6 | 63.7  75.2 |     167 |
 |-------------+---------+--------------+------------+------------+---------|
 | 15:00-16:00 | APPL286 |  1.43   0.33 | 88.7  92.3 | 88.3  92.9 |     620 |
 |             | APPL035 |  1.40   0.57 | 88.6  92.1 | 77.3  84.9 |     437 |
 |   229 Users | APPL134 |  2.21   0.79 | 73.4  85.9 | 75.8  84.7 |     162 |
 | In Interval | SYSUSR2 |  2.04   0.67 | 72.8  84.6 | 59.7  69.3 |     142 |
 +--------------------------------------------------------------------------+

Figure 3-18.  Sample Tabular Ranking Report


Use the Tabular Ranking Report option to list the top or
bottom n observations of the input file based on the
specified ranking element.  The ranking is presented in
Tabular Report format with columns of data values (for
example, response time, cost, etc.) over rows of ranked
observations (for example, userids). The listing includes
selected data elements from each file observation and is
useful in identifying areas for further study.  You can
optionally input detail observations, base the ranking on a
user-specified summarization of these detail observations,
and print the detail observations comprising the ranked
summary observations.  Summarization options include sum
(accumulate), maximum/minimum value, percent of total, and
percent/amount of change from the first observation.  A
subtotal derivation extended option is available to define
your own derived subtotal values (for example, average
response time).

Optional parameters allow you to generate multiple report
lines for each input file observation and to control the
specific column in which each item is printed.  Column
headings are specified for each data value or overridden with
free-form, multiple line column headings.  You can even
include footnotes on the report.

Figure 3-18 is a sample tabular ranking report providing a
ranking of TSO user activity by command count.

To create a tabular ranking report, select the Tabular
Ranking Report option from the Structured Inquiry Printed
Reports Menu.