Parameter

Description and Choices

Create Olap Mast Dimensions

Controls which dimensions are processed during DACRTOMAST.

*ALL

DACRTOMAST will process all dimensions.

Dimension Ids

DACRTOMAST will process the specified dimension. Enter the dimensions in a comma-delimited format.  Example: 2,3.

Truncate Table Before Loading

Set the parameter to 1 (Yes) if you want MASTxx tables to be cleared before they are loaded with Master File information. Use this option if you truncate the Stratum Master File tables before each load and you have either one or both of the LOAD Master File Data or Load Previous Level Data parameters set to 1.

Load Master File Data

Set the parameter to 1 (Yes) to load records from the Stratum Master File tables into the MASTxx tables for dimension values regardless of whether or not actual data exists for them in the Structure Code tables. This parameter ensures that Master File data exists for all dimension value combinations regardless of whether or not actual data exists for them in Structure Code tables of the Stratum database.

Load Previous Level Data

Set the parameter to 1 (Yes) to load all Previous Level Master File data into the MASTxx tables regardless of whether or not actual data exists for them in Structure Code tables of the Stratum storage database.

Connection String

Defines how this command process connects to the Stratum storage database. Valid entries are:

*GENERATE

The connection string will generate the DSN from the local Relational Database Directory Entry, the DBLIB from the library where file STCSUS10 resides, the USERID from the current user, and the PASSWORD from the current user.

A local Relational Database Directory must be defined for the command to process. The library list must contain a Stratum database library name.

*DEFINE

The connection string will be defined from parameters. If *DEFINE is selected, these four *DEFINE parameters must be entered for the connection string:

• DSN - Define the local Relational Database Directory Entry. Use "wrkrdbdire" to determine the local Relational Database Directory Entry. The directory entry must be a local location.

• DBLIB - Stratum database name.

• USERID - User ID.

• PASSWORD - Password of the User ID.

Program Library

Indicates the Stratum server library name. The program library will be added to the library list prior to command processing.

Submit to batch

Determines how a command job will be submitted. Valid entries are:

1= Yes

Set the parameter to 1 if you want to submit the job to batch.

0 = No

Set the parameter to 0 if you want to run the job online.

Log File Name

Can be used to designate the Integrated File System full path name of a log file for the command run, if you choose to have a log file generated.

Only one file can be used at a time. If executing multiple runs at the same time, define different log file names.

Inform record count

Can be used to indicate the number of records to process between informational messages about processing.

Number

The number of records to process between informational messages. If the setting is too low, it will cause large log files and slower performance.

Chain Length Warning

A Chain Length Warning occurs when a command is forced to allocate extra memory at Data Summary Level (DSL) load time because the number of header records that are being loaded exceeds the number of estimated number headers.

Number

If the number of chains exceeds the number defined here, a warning message is printed. This message does not mean that the process will fail, only that it is not functioning at peak performance.

Debug

Determines whether or not Debug messages will be generated during command processing. The Debug messages include all SQL statements used and other miscellaneous messages needed to debug any problem that may occur during processing. Valid entries are:

1= Yes

Set the parameter to 1 if you want messages generated.

0 = No

Set the parameter to 0 if you do not want messages generated.