8. WORKSHEET FACILITY › 8.5 Product Operation › 8.5.2 Worksheet Effect Reports
8.5.2 Worksheet Effect Reports
This section describes the screen and parameters that are
used to control the production of Worksheet Effect Reports.
The control parameters allow you to define the Capacity
Planning database file to be used as input, the time
periods, and the variables to be placed on the report. In
addition, you may subset the input data or tailor the
contents of the reports produced.
To get to the Worksheet Effect Report screen (shown in Figure
8-25) on your terminal, you must follow a short set of menus
which are more fully described in Section 1.5 of this guide.
The Worksheet Effect Report control screen appears after you
indicate that you want to insert a new Worksheet Effect
Report inquiry into your catalog of analysis inquiries. Two
fields are filled on the fourth line when you first see it:
the inquiry name and the inquiry description, separated by a
dash. You enter these two fields on the Insert Capacity
Planning Analysis screen when you request that a new inquiry
be added.
/--------------------------- Worksheet Report --------------------- Row 1 of 63\
|Command ===> Scroll ===> CSR |
|Enter a ? in any data entry field for more information on valid values. |
|Composing CA MICS Inquiry: WRKREP - Worksheet Testing - Effect Report |
| |
|Creating Worksheet Inquiry: WK1R01 - WORKSHEET WITH 9 CAPAPUS |
| |
|Report Title ===> Worksheet Testing - Effect Report |
|Selection criteria: |
| Input file ===> ___ (fff) - |
| SYSID ===> ____ |
| HOUR ===> __ |
| Specify CAPAPU values ===> _ (Y/N) |
| |
|Number of previous weeks ===> ____ (1-9999) |
|Number of future weeks ===> ____ (1-9999) |
|Specify Extended Options ===> N (Y/N) |
| |
| Name Label Line One Label Line Two Output Format Include Forecast |
| -------- -------------- -------------- --------------- ---------------- |
| PPASRBTM PPASRBTM ______________ TIME12.2 NO |
| PPATCBTM PPATCBTM ______________ TIME12.2 NO |
| ________ ______________ ______________ _______________ ___ |
| ________ ______________ ______________ _______________ ___ |
| ________ ______________ ______________ _______________ ___ |
| ________ ______________ ______________ _______________ ___ |
\------------------------------------------------------------------------------/
Figure 8-25. Worksheet Effect Report Control Screen
Some of the parameters in Figure 8-25 are required, while
others are optional. The following is a discussion of the
various parameters as they appear in this figure.
Report The 60-character title field for the Worksheet
title: Effect Report. No double quotes (") or
semicolons (;) may appear within the body of the
title.
Input file: The resource element or business element Capacity
Planning database file that contains the
historical observations to be used as input to
the report. If you are uncertain of the files
or file names available in your Capacity Planning
database, type a question mark (?) in the field
and a selection list will be displayed.
SYSID: The SYSID for which the report is to be produced.
If the Capacity Planning database file was
defined as having a composite SYSID, this value
is automatically supplied on the screen.
Hour: The Zone, Hour or Dayname from the input file you
would like on the worksheet. This is a required
field for all input files except for a business
element file, in which case it is not used.
Specify Put a Y in this field to specify the CAPAPU
CAPAPU value(s) to be included in the analysis. The
values: CAPAPU value is specified on the CAPAPU
Selection Values screen, shown in Figure 8-26,
that appears if you enter a Y in this field. You
may specify it only if the Capacity Planning
database file is defined as containing the CAPAPU
data element.
Number of The number of days, weeks, or months (depending
previous on the specification of the input file) of
weeks: actual data you would like on the Worksheet.
Number of The number of days, weeks, or months (depending
future on the specification of the input file) of
weeks: user forecast fields you would like on the
worksheet.
Specify A Y in this field will take you to the Extended
Extended Options Menu (see Figure 8-27 for an example of
Options: this screen). The Extended Options Menu allows
you to optionally add a list of comments to the
generated report and/or write your own SAS code
to subset the input file.
The lower portion of the control screen contains a scrollable
data entry display in which you may specify the data elements
to be included on the report. Blank entries represent blank
columns. The following fields are available for each row in
the display area:
Name: The name of the data element to be included on
the report. If you are uncertain as to the
correct name of the data elements on the input
file, type a question mark (?) in this field and
a selection list of available data elements will
be presented.
Col. The first and second lines of the column heading.
Heading 1 The maximum permissible length for the column
and Col. headings is 12 characters. No double quotes (")
Heading 2: or semicolons (;) may appear within the body of
the headings.
Output The output format that is used to print the
format: values for this data element in the reports. The
report field is 12 columns wide, so any value
that you enter here should specify a field width
of 12, or the values will not be right-justified.
If you specify a format value on the CA MICS File
and Data Element Selection screen when the Input
file is defined, this value is supplied
automatically as a default. If you do not specify
any value here, then the Profile and Trending
Analysis uses one of two default output formats.
For any data element name that ends in the
characters TM, a SAS format of TIME12.2 is used.
All other data elements default to a SAS format
of 12.2.
/-------------------------- CAPAPU Selection Values --------------------------\
|Command ===> |
|Composing CA MICS Inquiry: ______ _______________________________ |
| |
| Rule ----+----1----+----2----+----3----+----4----+---5----+----6--- |
|CAPAPU ===> _______________________________________________________________ |
|CAPAPU 2 ===> _______________________________________________________________ |
|CAPAPU 3 ===> _______________________________________________________________ |
|CAPAPU 4 ===> _______________________________________________________________ |
|CAPAPU 5 ===> _______________________________________________________________ |
|CAPAPU 6 ===> _______________________________________________________________ |
|CAPAPU 7 ===> _______________________________________________________________ |
|CAPAPU 8 ===> _______________________________________________________________ |
|CAPAPU 9 ===> _______________________________________________________________ |
| |
| |
\------------------------------------------------------------------------------/
Figure 8-26. CAPAPU Selection Values Screen
/------------------- CAP File Processing Extended Options Menu ---------------\
|Command ===> |
| |
|Inquiry Step: WRKREP - Worksheet Testing - Effect Report |
| |
| |
|Specify file selection criteria. ===> N (Y/N/R) |
| (file subsetting exit) |
| |
|Specify footnotes for the reports. ===> N (Y/N/R) |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
\------------------------------------------------------------------------------/
Figure 8-27. CAP File Processing Extended Options Menu
Figure 8-27 shows the CAP File Processing Extended Options
Menu that is displayed if you specify a Y (YES) for the
Specify Extended Options parameter on the Worksheet Effect
Report screen shown in Figure 8-25.
The following options are available:
o Specify file selection criteria -The specification for
building a SAS Macro to subset the input Capacity Planner
File. See Figure 8-29 to see the screen that is displayed.
Specify a 'Y' to create/update the macro. Specify an 'R'
to reset (clear) any macro that may be there.
o Specify footnotes for the worksheets--The specification for
placing footnotes at the bottom of the effect reports. See
Figure 8-28 to see the screen that is displayed. Specify
'Y' to place footnotes on the worksheet; specify 'R' to
reset (clear) any footnotes that are already defined.
When you are finished with this screen, END to return to the
Worksheet Effect Reports Control screen (see Figure 8-25).
/---------------------------- SAS System Statements --------------------------\
|Command ===> Scroll ===> CSR |
| |
|Inquiry Step: WRKREP - Worksheet Testing - Effect Report |
|************************************ TOP OF DATA ******************************|
|==MSG> SPECIFY SAS STATEMENTS TO SUBSET THE CAPACITY PLANNING DATA BASE FILE. |
|=NOTE= %MACRO SELECT; <=== PLEASE DO NOT PLACE LINES BEFORE THIS LINE. |
|000001 |
|000002 |
|000003 |
|000004 |
|000005 |
|000006 |
|000007 |
|000008 |
|000009 |
|000010 |
|000011 |
|000012 |
|000013 |
|000014 |
|=NOTE= %MEND SELECT; <=== PLEASE DO NOT PLACE LINES AFTER THIS LINE. |
|*********************************** BOTTOM OF DATA ****************************|
\------------------------------------------------------------------------------/
Figure 8-28. SAS Statements to Subset the Input File
Figure 8-28 shows the SAS System Statements screen that you
use to code a SELECT macro that will be used to subset the
input Capacity Planner file. This is a table display screen.
See Section 1.5 for more information on how to use this type
of screen. Save any changes you made. Enter the END command.
/---------------------- Worksheet Effect Report Footnotes ---------------------\
|Command ===> Scroll ===> CSR |
|SAS statements for the specified exit (SELECT macro) have been deleted. |
|Specify footnotes that will appear at the bottom of the report page. |
| |
|Line Comments |
| - --------------------------------------------------------------------------|
| 1 _________________________________________________________________________ |
| 2 _________________________________________________________________________ |
| 3 _________________________________________________________________________ |
| 4 _________________________________________________________________________ |
| 5 _________________________________________________________________________ |
| 6 _________________________________________________________________________ |
| 7 _________________________________________________________________________ |
| |
\------------------------------------------------------------------------------/
Figure 8-29. Worksheet Effect Report Footnotes Screen.
Figure 8-29 shows the Worksheet Effect Report Footnotes
screen. You can specify up to seven lines of footnotes for
the report. To save your footnotes without leaving this
screen, enter the SAVE command. To void any changes made to
this screen, enter the CANCEL command. To leave this screen
and save any changes you made, enter the END command.
Copyright © 2014 CA.
All rights reserved.
|
|