Previous Topic: Batch Forecasting (CAKRFCSB)

Next Topic: Forecast Methods Summary


CAKRFCST Control Statements

You enter the batch statements via the SYSIN DD statement of the CAKRFCST SAMPJCL.

The following keywords define CA PMA Chargeback Forecast control statements. The format is: keyword = value. If no value is specified for the control statement, all records from the CCCTAB table are applicable.

ORD_TYPE =

Records from the CCCTAB table are selected based on this three-character output record identifier name.

ELEMENT =

Records from the CCCTAB table are selected based on this charge element (up to 16 alphanumeric characters).

START_PERIOD =

The start of the range of records which are selected from the CCCTAB table. Selections for this control statement should be three-character numerics.

END_PERIOD =

The end of the range of records which are selected from the CCCTAB table. Selections for this control statement should be three-character numerics.

Note: It is recommended that forecasting be performed only on closed periods. This ensures that the data used for forecasting is accurate. Refer to the period closing process for details.

QUALIFIER =

Records from the CCCTAB table are selected based on this conditional test. You can specify up to 16 alphanumeric characters.

STRUCT1 =

Specify the name of the defined accounting level for which records are selected.

STRUCT2 =

Specify the name of the defined accounting level for which records are selected.

STRUCT3 =

Specify the name of the defined accounting level for which records are selected.

STRUCT4 =

Specify the name of the defined accounting level for which records are selected.

STRUCT5 =

Specify the name of the defined accounting level for which records are selected.

The following control statements determine how the CCCMOD table is generated, and the form in which its contents are stored.

AVERAGE =

Determines if the projected periods that result from forecasting are stored individually or as one average projected period in the CCCMOD table. Valid entries are Y or N.

ALGORITHM =

The forecast method or copy function to be performed. Valid entries for this field are:

COPY

Records from the CCCTAB table are copied to the CCCMOD table based on the periods specified for the START_PERIOD and END_PERIOD control statements and any selection criteria.

LINE

The periods specified for the START_PERIOD and END_PERIOD control statements are used by the Line algorithm to compute the weighted moving average. The weighted moving average forecasts the number of periods specified for the NUMBER_TO_FORECAST control statement.

SMOOTH

The Smooth algorithm is an exponential method of forecasting. It is especially useful when recent consumption and charge values predict future values better than those of the more remote past. User-defined control statements Alpha and Delta are used as smoothing constants when Smooth is specified.

ALPHA =

This control statement is applicable only when SMOOTH is specified as the ALGORITHM. Alpha is used to modify or lessen the effects of short term or random changes. There is no default: up to four decimal values are permitted. Values can be between 0 and 1.

DELTA =

Is applicable only when SMOOTH is selected as the ALGORITHM. Delta is used to determine the level of smoothing and the speed of reaction to differences between forecasts and actual usage. Acceptable values are between 0 and 1.

MODIFIER =

A five-character control statement that determines how modifier records are used during the forecast process. Not applicable to the COPY algorithm. Valid entries include:

YES

Modifier records are treated as separate records for the forecast process. A forecast generated using this option depicts a true financial forecast.

NO

Modifier records are not considered during the forecast process. This option is used when you are concerned with unit utilization.

MERGE

If a given record has a modifier record(s) associated with it, the modifier record(s) is combined with the original record to form one record.

NUMBER_TO_FORECAST =

This control statement specifies the number of periods projected into the future. Acceptable values are three-character numerics. Not applicable to the COPY algorithm. Note:

KEEP_STRUCTURE =

This control statement indicates the accounting levels maintained on the CCCMOD table. You can specify any number between 1 and 5, or 0. Not applicable to the COPY algorithm.

Records are grouped and summarized by the accounting level(s) selected. For example, entering a 1 indicates that the highest accounting level will be maintained. Records with similar highest accounting level are grouped and summarized on the CCCMOD table. Entering a 5 indicates that all accounting levels are maintained and no summarization is to take place.

VERSION =

Specifies the full eight-character CA PMA Chargeback version name used in the forecast. You can specify multiple versions by using the SQL wildcard character, along with any combination of alphanumeric characters. The VERSION control statement is used for both selection criteria and forecast generation.

Note: Before using the online Period functions to view the CCCMOD table, ensure that the version used in the Options function. is the same as the one specified for this control statement.

If you specify the SQL wildcard for this control statement, the CCCMOD table retains only the last version. This is the version that MUST be used in the Options function.