Previous Topic: 3.3.2 Crosstabulation Report

Next Topic: 3.3.4 N-Way Crosstabulation Report

3.3.3 Three-Way Crosstabulation Report


                         TABLE 1 OF CICSID BY SYSID
                         CONTROLLING FOR CICSVER=17

                CICSID(CICS SYSTEM )     SYSID(MVS SYSTEM )

                FREQUENCY|
                 ROW PCT |MVS1    |MVS2    |MVS3    |  TOTAL
                ---------+--------+--------+--------+
                ACCT     |  10391 |      0 |   2044 |  12435
                         |  83.56 |   0.00 |  16.44 |
                ---------+--------+--------+--------+
                OIL1     |      0 |  35892 |  16599 |  52491
                         |   0.00 |  68.38 |  31.62 |
                ---------+--------+--------+--------+
                OIL2     |    729 |  19808 |   9938 |  30475
                         |   2.39 |  65.00 |  32.61 |
                ---------+--------+--------+--------+
                TOTAL       11120    55700    28581    95401
                (CONTINUED)

Figure 3-21.  Sample Three-Way Crosstabulation Report


The Three-Way Crosstabulation Report is an extension of the
crosstabulation report to three variables.  It shows the
first two variables for each value of the third variable.

For example, you might have created a variable USERGRP that
groups your systems users into a small number of categories.
You might then create a three-way crosstabulation showing
SYSID by COMMAND for each of value of USERGRP.  Such an
analysis could be useful in determining who is in need of
training or who is making the greatest use of specific
resources.

Figure 3-21 is a partial sample of a three-way
crosstabulation report and shows, by the version of CICS
being used (CICSVER), the number of CICS transactions by CICS
system (CICSID) and SYSID.  Observations are weighted by the
number of transactions (CSYTRANS).  A separate report is
produced for each CICS version.

To create a three-way crosstabulation report, select the
Three-Way Crosstabulation Report option from either of the
following menus:

o  Direct Inquiry Statistical Analysis Menu
o  Structured Inquiry Statistical Analysis Menu