Previous Topic: 14.5 Component OperationNext Topic: 14.5.2 Analysis File Data Elements Selection Screen


14.5.1 Workload Forecasting Analysis Control Screen


The Workload Forecasting Analysis control parameters allow
you to develop forecast models based on Neugents technology.
You can optionally save the forecasts produced by the program
in a Capacity Planning Forecast file for additional analysis
or presentation.

Using a short set of menus that are described in Section 1.5
of this guide, takes you to the Workload Forecasting Analysis
Control Screen shown in Figure 14-9.  This screen appears
after you indicate that you want to insert a new Workload
Forecasting Analysis Query.  Two fields on this screen are
filled in on the third line when you first see it:  the
inquiry name and the inquiry description, separated by a
dash.  You entered these two fields on the Insert Capacity
Planning Analysis screen when you requested that a new
inquiry be added.

/--------------------  Workload Forecasting Analysis  --------------------------\
|Command ===>                                                                   |
|Enter a ? in any data entry field for more information on valid values.        |
|            CA MICS Inquiry: CPW - Sample Workload Forecasting Query           |
|Report title ===> Processor Usage Forecast                                     |
|                                                                               |
|Model Data Selection:                                                          |
|Primary CAP file ===> APU          Forecast length ===> 13                     |
|Forecast element ===> CPUADBTM  Forecasting Method ===> AUTOMATIC (Manual/Auto |
|      Start date ===> 01JUN200   Adjustment Option ===> INTERVAL  (Int./Annual |
|           SYSID ===> SYSB        Specify elements ===> YES       (YES/NO)     |
|            ZONE ===> 1       Select Elements from ===> APU       (CAP file)   |
|       No. Weeks ===> 53             Save forecast ===> CHK    (YES/NO/AGE/CHK)|
|   CAPAPU Values ===> NO        Alerting Threshold ===> NO     (00-99 Percent) |
|                                 Activate Alerting ===> NO     (YES/NO)        |
|                                                                               |
|------------------------------------------------------------------------------ |
|Output Generation Options:                                                     |
|Forecasting Report            ===> YES       Color ===> NO   CSV ===> NO       |
|Regression Residuals Report   ===> NO        Color ===> NO   CSV ===> NO       |
|    Color graphics format set ===> TERMINAL                                    |
|Output Formatting Options:                                                     |
|Format for Predicted Values   ===> HOUR                                        |
|HAXIS Interval Values         ===> QTR      Format ===> MONYY                  |
\------------------------------------------------------------------------------/

 Figure 14-9.  Workload Forecasting Analysis Control Screen

Some of the parameters on the Workload Forecasting Analysis
screen shown in Figure 14-9 are required, while others are
optional.  The following is a discussion of the various
parameters as they appear in this figure.


PARAMETER:        DESCRIPTION / USAGE:

Report        The 60-character title for Workload Forecasting
title:        Analysis using Neugents technology reports.  No
              double quotes (") or semicolons (;) may appear
              within the body of the title.

Primary       The capacity planning database file containing
CAP file:     the historical observations for the forecast
              variable of the model.  This file may be either
              a Sample Application or user defined Resource
              Element file, but must reside in the Capacity
              Planning database.  If you are not sure 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.

Forecast      The name of the Forecast variable in the model.
element:      If you are not sure of the correct name of the
              data elements in the input file, type a
              question mark (?) in this field and a selection
              list of available data elements will be

Start date:   The start date for date range selection.  If
              Start date is specified, only historical
              observations at least as recent as this value
              will be included in the analysis.

SYSID:        The SYSID for which the report is to be
              produced. Note that the Secondary CAP file
              (specified under "Select Elements from" on the
              screen) must also contain historical
              observations for this SYSID.

LVL:          The LVL field was reset to Zone because the
              data was summarized by Zone. The Zone, Hour or
              Dayname to be included in the analysis,
              depending on whether you define the Primary CAP
              file at the ZONE, HOUR, or DAYNAME
              summarization level.  The Secondary CAP file
              must also contain historical observations for
              this ZONE, HOUR or DAYNAME. The field name will
              automatically be changed from LVL to either
              ZONE, HOUR, or DAYNAME to reflect the Input
              file summarization level once you specify the
              Input file.

No. wk/mn:    The maximum number of days, weeks, or months of
              historical observations included in the
              analysis.  Note that the field name will change
              once you specify the file to reflect the
              timespan of the Primary CAP File.  When used in
              conjunction with the Start date parameter,
              several options are available for date range
              selection control:

              o  If you specify only Start date, all
                 historical observations at least as recent
                 as the value specified for Start date will
                 be selected.

              o  If you specify both Start date and No.
                 wk/mn, the date range for data selection
                 will begin with the value specified for
                 Start date and will extend for the specified
                 number of days, weeks, or months.

              o  If you specify only No. wk/mn, the date
                 range for data selection will include only
                 this number of the most recent days, weeks,
                 or months.

              o  If you do not specify a parameter, then all
                 historical observations will be selected.

Specify       Put a Y in this field to specify the CAPAPU
CAPAPU        value(s) (up to nine) to be included in the
Values:       analysis.  The CAPAPU values are specified on
              the CAPAPU Selection Values screen shown in
              Figure 14-10.  You may specify CAPAPUs only if
              the Primary CAP file is a resource element file
              and is defined as containing the CAPAPU data
              elements.  Note that the Secondary CAP file
              must also contain historical observations for
              the specified CAPAPU values.

Forecast      The length of a forecast period, in terms of
the Length:   timespan assumed by the Primary CAP file. In
              other words, a Forecast Length of 13 when the
              Primary CAP file is summarized at the WEEKS
              timespan would be 13 WEEKS. A non-zero value is
              required; the current default value is 1.

Forecasting   AUTOMATIC (default) indicates that the Workload
Method:       Forecasting application will determine the
              adjustment values for each selected training
              element. MANUAL indicates that the analyst will
              specify the adjustment values on panel CAPG710.
              Changing this value from AUTOMATIC to MANUAL
              forces the Specify Elements value to be set to
              YES.

Adjustment    INTERVAL (default) causes the Adjustment value
Option:       to be applied equally across the Forecast
              Length period. ANNUAL causes the Adjustment
              value to be annualized before application. For
              example, an Adjustment value of 20 percent for
              a particular workload (training element) would
              be applied evenly across a 13 week Forecast
              Length if MANUAL is specified, resulting in a
              20 percent increase in workload processor time
              by the end of the forecast period. Specifying
              ANNUAL would cause the 20 percent increase to
              be taken across one year, and the resulting
              increase then applied across the forecasting
              period. In this case, the workload processor
              time would be increased by 5 percent by the end
              of the forecasting period.

Specify       YES (default) forces the display of panel
Elements:     CAPG710 when panel CAPG700 is "ended". Panel
              CAPG710 is used to select a set of elements to
              be used for training, as well as to specify an
              adjustment percentage when using MANUAL
              adjustments.

Select        The file that contains the data elements used
Elements      for the training phase.  This will default to
from:         the same file specified for the Primary CAP
              file, but may be any Sample Application, user
              defined Resource Element or Business Element
              Forecasting file that resides in the Capacity
              Planning database.  If you are not sure 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.

Save          YES/NO/AGE/CHK determines if a file
Forecast:     containing the forecasted future values of
              the Analysis element should be saved by
              itself (YES), saved and aged across three
              cycles (AGE), used only for ALERT detection
              and processing (CHK) or ignored (NO, the
              default) value.

              o  Specifying YES causes the forecasted
                 observations to be saved in the Capacity
                 Planning database Forecast file (CPFxxx01)
                 without aging the file as described in
                 Chapter 3.

              o  Specifying AGE causes the forecasted
                 observations to be saved in the Primary CAP
                 file and be aged as described in Chapter 3.

              o  Specifying NO results in the forecasted
                 observations not being saved in the Forecast
                 file.  If you select this option, the
                 Forecast file will not be aged.

              o  Specifying CHK results in the forecasted
                 observations being used to detect and
                 process ALERTS.  If you select this option,
                 no new Forecast file will be created but a
                 Forecast file must exist.

Alerting      A value from 01 to 99 percent, or "NO," if the
Threshold:    the Save Forecast option does not specify
              'CHK'.  This value is used to determine the
              threshold values used for evaluating whether an
              Alert should be raised. The default value is 10
              percent.  Using the default for example, an
              Alert would be raised if the current Actual or
              Forecasted value deviated from the Baseline
              Forecast value by 10 percent.

Activate      YES / NO specifies whether the Service Desk
Alerting:     facility is available and used for Alert
              processing (YES) or that Alert processing is
              handled internally only (NO).

OUTPUT GENERATION OPTIONS:

Forecasting   YES / NO specifies whether a printer report of
Report:       the training and forecasted values, along with
              the model evaluation statistics should be
              printed (YES) or ignored (NO).

Regression    YES / NO specifies whether a printed report of
Residuals     linear regression residual values should be
Report:       printed (YES) or ignored (NO). This is a
              special case where the client wants to perform
              an exploratory data analysis on the Forecast
              element values.  A linear regression procedure
              is executed against Forecast element values.
              The regression residual values are presented so
              that their values can be observed and verified.

              Note:  This report is not currently available,
                     but a graph of residuals is produced
                     automatically.

Color:        YES / NO (Default is NO). Specifies whether a
              high resolution graphics should be generated.

CSV:          YES / NO (Default is NO). Specifies whether a
              CA MICS Q&R WorkStation compatible comma
              separated value (CSV) file should be generated
              (YES) or ignored (NO). This file can be
              downloaded to a PC and used to generate graphs
              using the CA MICS Q&R WorkStation.


OUTPUT FORMATTING OPTIONS:

Format for    TIME / HOUR / MINUTE specifies how predicted
Predicted     values will be formatted in output operations.
Values:       The default value of null causes the predicted
              values to assume the same format as the
              original Analysis element.  A value of TIME
              causes a SAS format of TIME10.0 to be used. A
              value of HOUR causes a SAS format of HOUR6.4 to
              be used. A value of MINUTE causes time values
              to be first converted to minutes and then
              displayed using a SAS format of 5.0.

HAXIS         DAY / WEEK / MONTH / QTR specifies the units
Interval      used for HAXIS values for printer graphs. The
Values:       default value of null causes the HAXIS values
              to be assigned using the timespan of the
              Analysis file.

HAXIS         DATE / DDMMYY / MMDDYY / YYMMDD / MMYY / MONYY
Interval      causes various SAS formats to be used for the
Format:       HAXIS values for printer graphs. The SAS
              formats used are as follows:

              DATE      DATE9.
              DDMMYY    DDMMYY10.
              MMDDYY    MMDDYY10.
              YYMMDD    YYMMDD10.
              MMYY      MMYYC7.
              MONYY     MONYY7.

              The default value of null causes a SAS format
              of DATE9.

If you entered a "Y" in the CAPAPU Values field on the
Workload Forecasting Analysis screen, the CAPAPU Selection
Values screen displays, as shown in Figure 14-10.  On this
screen, you can specify the CAPAPU values (up to nine) to be
included in the analysis, only if the capacity planning
database file is defined as containing the CAPAPU data
elements.

/-------------------------  CAPAPU Selection Values  -------------------------\
|Command ===>                                                                 |
|                                                                             |
|Composing CA MICS Inquiry: Neugents Workload Forecasting with CAPAPU         |
|                                                                             |
|         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 14-10.  CAPAPU Selection Values Screen