Previous Topic: 8.5.1.2 Modifying a WorksheetNext Topic: 8.5.1.4 Entering a Worksheet


8.5.1.3 Producing a Worksheet


This section describes how to produce a worksheet. The
PRODUCE function will invoke MICF execution facilities to
generate an inquiry that can be executed.  This process
creates the Worksheet Report and member in the Capacity
Planner data set that contains the data you requested.  Once
the worksheets have been filled in, you can use the ENTER
function of the Worksheet Facility to enter these values into
the Capacity Planner data set for later APPLY processing.

/---------------------  Capacity Planner Worksheet Catalog ---------------------\
|Command ===>                                                  Scroll ===> CSR  |
|                                                                               |
|Commands:  Apply, Create, End, Enter, Help, Menu, Modify, Produce, Return,     |
|           Select                                                              |
|                                                                               |
|Command   Name                   Title                  File    Status         |
|-------- ------ --------------------------------------- ---- ----------------  |
|________ BEF001 Business Element File - Invoice File    BF1  Produced 08AUG97  |
|PRODUCE  TEST01 Testing Worksheets - CPU Stnd. Appl.    C10  Modified 25JUL97  |
|________ WRK001 Worksheet Built From WKL Stnd. Appl.    Wk1  Entered 19SEP97   |
|****************************** BOTTOM OF DATA  ********************************|
|                                                                               |
|                                                                               |
|                                                                               |
|                                                                               |
|                                                                               |
|                                                                               |
|                                                                               |
\------------------------------------------------------------------------------/

 Figure 8-13. Worksheet Catalog.

Figure 8-13 shows the Worksheet Catalog with 'PRODUCE'
entered in front of the Worksheet Definition TEST01.
Entering 'PRODUCE TEST01' on the Command Line has the same
effect.  The Capacity Planner verifies that the worksheet
definition can be produced (that is, is executable) and then
invokes the MICF Execution Facility to produce the worksheets
and update the Capacity Planner Data Set.


/----------------------------  MICF Execution  ---------------------------------\
|Command ===>                                                                   |
|                                                                               |
|Executing CA MICS Inquiry: TEST01 - Testing Worksheets - CPUStnd. Appl.        |
|                                                                               |
|Inquiry Execution Mode     ===> BATCH      (BATCH/FOREGROUND)                  |
|Override Execution Options ===> N          (Y/N)                               |
|SAS/DMS Options:  Resume   ===> Y          (Y/N)    Output Replay ===> Y (Y/N) |
|                                                                               |
|                                                                               |
|Press ENTER to execute the inquiry, or press END to cancel execution.          |
|                                                                               |
|----------------------  Batch Job Submission Parameters  ----------------------|
|Edit Generated Jobstream%===> N (Y/N)  Hold Inq. Output for Replay ===> N (Y/N)|
|                                                                               |
|SYSOUT Class  ===> A                               SYSOUT Form  %===> ____     |
|Destination  %===> ____                            SYSOUT Writer%===> ________ |
|SYSOUT Parms.%===> ___________________________________________________________ |
|                                                                               |
|Job Card Information:                                                          |
|   ===> //jobname  JOB (accounting information),                               |
|   ===> // MSGLEVEL=(1,1),MSGCLASS=A,PRTY=5                                    |
|   ===> //*                                                                    |
|   ===> //*                                                                    |
|                                                                               |
|                                                                               |
\------------------------------------------------------------------------------/

 Figure 8-14.  CA MICS Worksheet Inquiry Execution Screen

For more information about the CA MICS Worksheet Inquiry
Execution Screen shown in Figure 8-14, see Section 1.5 of
this guide.

/---------------------  Capacity Planner Worksheet Catalog ---------------------\
|Command ===>                                                  Scroll ===> CSR  |
|                                                                               |
|Commands:  Apply, Create, End, Enter, Help, Menu, Modify, Produce, Return,     |
|           Select                                                              |
|                                                                               |
|Command   Name                   Title                  File    Status         |
|-------- ------ --------------------------------------- ---- ----------------  |
|________ BEF001 Business Element File - Invoice File    BF1  Produced 08AUG97  |
|________ TEST01 Testing Worksheets - CPU Stnd. Appl.    C10  Produced 25JUL97  |
|________ WRK001 Worksheet Built From WKL Stnd. Appl.    Wk1  Entered 19SEP97   |
|****************************** BOTTOM OF DATA  ********************************|
|                                                                               |
|                                                                               |
|                                                                               |
|                                                                               |
|                                                                               |
|                                                                               |
|                                                                               |
\------------------------------------------------------------------------------/

 Figure 8-15. Worksheet Catalog. After Worksheet Production.

Once the worksheet is produced, you are returned to the
Worksheet Catalog and the Status Field is updated to reflect
the change.