PROBLEM:
Charging for the use of transactions executed in CICS is
a difficult problem and requires an analysis of how the
transactions are used and what is the relative portion of
the cost recovered that they represent.
DATABASE FILES TO BE ACCESSED:
&PCICM..CICCSU01-03
Last three month's of CICS User Activity Files.
Note that we assume the default account code
structure is being used so that CICACT2 contains the
transaction ID.
SUGGESTED SAS FACILITIES TO BE USED FOR REPORTING:
PROC CHART run in bar chart form for a distribution of
all transactions, with a PROC CHART pie chart to
illustrate cost portion of the major transactions.
SAS CODE EXAMPLE:
************************************************************;
* CICS TRANSACTIONS FINANCIAL ANALYSIS *;
************************************************************;
DATA;
SET &MCICM..CICCSU01 &MCICM..CICCSU02 &MCICM..CICCSU03;
FORMAT CSUCOST DOLLAR9.2;
CSUCOST=(CSUCPUTM * 0.06) + (CSUEXCPS/1000 * 3.60) +
(CSUTRANS * 0.05);
OPTIONS S=62; /*FOR TITLE 2*/
PROC CHART; HBAR CICACT2 / TYPE=SUM
SUMVAR=CSUCOST DESCENDING;
TITLE "CICS TRANSACTIONS FINANCIAL ANALYSIS";
TITLE2 "CHARGING ALGORITHM OF $0.06 PER CPU SECOND, $3.60 PER
1000/EXCPS, AND $0.05 PER TRANSACTION";
%LET BY = CICACT2;
%LET BREAK = CICACT2;
PROC SORT; BY &BY;
OPTIONS S=72;
DATA;
SET;
%CSUSUM;
PROC SORT; BY DESCENDING CSUCOST;
DATA;
SET;
IF _N_ > 12 THEN CICACT2='*OTHERS*';
OPTIONS S=62; /*FOR TITLE 2*/
PROC CHART; PIE CICACT2 / TYPE=SUM
SUMVAR=CSUCOST;
TITLE "TOP 12 CICS TRANSACTIONS FINANCIAL ANALYSIS";
TITLE2 "CHARGING ALGORITHM OF $0.06 PER CPU SECOND, $3.60 PER
1000/EXCPS, AND $0.05 PER TRANSACTION";
GENERATED OUTPUT REPORT:
Figures 6-7 and 6-8 illustrate the output reports
produced by the SAS code illustrated above.
CICS TRANSACTIONS FINANCIAL ANALYSIS 12:05 Friday, September 3, yyyy 1 CHARGING ALGORITHM OF $0.06 PER CPU SECOND, $3.60 PER 1000/EXCPS, AND $0.05 PER TRANSACTION PROCESSING CHARGE TRANSACTION ID FREQ SUM | DADB |********************************************************************** 169 $14085.40 CSMI |********************************************************************** 3 $14055.40 AE30 |**************************************************** 3 $10449.70 CPLT |************************************************* 53 $9818.11 XXXI |************************************* 85 $7309.09 TIM2 |********************* 122 $4193.99 TOCN |******************** 215 $3935.83 STAT |****************** 47 $3525.92 MNMQ |***************** 49 $3456.57 DB2X |*************** 14 $3027.24 CSSY |************* 8 $2692.31 SX01 |*********** 13 $2193.23 SX03 |*********** 65 $2141.29 SX02 |*********** 86 $2110.91 SX04 |********** 12 $1918.11 SMXK |********* 3 $1856.94 SMXJ |********* 19 $1789.30 TAUT |********* 45 $1715.24 IBSR |******* 13 $1443.14 ZQMZ |******* 32 $1399.11 MT4I |******* 139 $1338.01 PACQ |******* 4 $1326.49 VTG1 |******* 50 $1324.83 ICM7 |****** 3 $1255.31 OPTD |****** 128 $1179.78 MN4I |**** 62 $869.34 SX05 |**** 14 $827.68 SMXO |**** 48 $727.58 SMXN |**** 5 $726.20 DADT |*** 181 $639.83 MDRL |*** 6 $629.65 TRFK |*** 27 $588.71 TBAT |** 15 $493.78 CWBG |** 6 $488.45 TRF1 |** 14 $477.05 MLGS |** 49 $454.21 IB36 |** 60 $413.28 IB3C |** 3 $383.18 IB3D |** 22 $382.16 IB3A |** 12 $354.27 IB3B |** 16 $345.28 FFOF |** 1 $336.87 IBA6 |** 9 $324.67 IBAC |** 5 $324.50 ----------+---------+---------+---------+---------+---------+---------+ $2000.00 $4000.00 $6000.00 $8000.00 $10000.00 $12000.00 $14000.00
Figure 6-7. CICS Transactions Financial Analysis
TOP 12 CICS TRANSACTIONS FINANCIAL ANALYSIS 12:33 Friday, September 3, 2010 1 CHARGING ALGORITHM OF $0.06 PER CPU SECOND, $3.60 PER 1000/EXCPS, AND $0.05 PER TRANSACTION Sum of CSUCOST by CICACT2 ***************** ***** ***** AE30 **** . **** *** . *** ** . ** *OTHERS* *** . *** * . * ** . . ** ** . .. ** CPLT ** .. 10193.93 . ** ** . 8.15% . ** ** .. . ** * . . 36351.91 * ** .. $6222.52. . 29.07% ** * .. 4.98% .. . * * ... . . * ** .. . . ** * .. .. . * ** .. . . ** * .. .. . * * .. . . * * .. . . * CSMI * 17690.23 ... * * 14.15% + . . .. . .. . .. . .. . .. . .. . .* * . . .. .. * * .. . .... .. . $6444.56 * * . .. . .. . .. .. 5.15% * * . . ....... . .. * Other ** . . . .. . .. .. . ** * . . . ... . .. . . . * ** .. . . . . . $5992.76 . .** * .. . . .. .. 4.79% * *. . . .$3156.34 * ** . . .2.52%. ** ** .. $3250.99 . . ** XXXI ** 33072.31 . 2.60%. .. ** ** 26.45% $2683.84 .. .** ** 2.15%. . ** ** . .. . ** ** . . .** TOCN * . . * *** . . *** TIM2 ** .. ** *** *** STAT **** **** ***** ***** DADB *****************
Figure 6-8. Top 12 CICS Transactions Financial Analysis
|
Copyright © 2014 CA.
All rights reserved.
|
|