Editing Procedures

After you specify a data source, identify all variables, and define all mapping instructions, TurboIntegrator generates four procedures that are based on the options you selected in the TurboIntegrator tabs. These procedures are identified as sub-tabs of the Advanced tab.

The procedures are:

Tab	Description
Prolog	A series of statements to be executed before the data source is processed.
Metadata	A series of statements that update or create cube, dimensions, and other metadata structures during processing.
Data	A series of statements that manipulate values for each record in the data source.
Epilog	A series of statements to be executed after the data source is processed.

You can edit these procedures to include TurboIntegrator functions and TM1® rules functions that extend the capabilities of TurboIntegrator. For example, you can edit the Data procedure to include statements that instruct the process to skip records containing zero values, or to write imported records to an external file.

For a complete list of all available TurboIntegrator and TM1 rules functions, see the IBM® Cognos® TM1 Reference.

When editing procedures, keep in mind that each procedure is intended to execute certain types of actions at specific times in a process. Accordingly, you should create actions or statements that are appropriate for a given procedure.

Note: When the data source for a process is NONE, the Data and Metadata procedures are ignored when the process is executed. Any functions or statements on the Data or Metadata sub-tabs are not executed, but TM1 does not issue an error or warn you that part of the process was not executed.

To edit a procedure:

Procedure

Click the Advanced tab.
Click the sub-tab for the procedure you want to edit.
Enter your statements in the text box either before this line:
```
#****GENERATED STATEMENTS START****
```
or after this line:
```
#****GENERATED STATEMENTS FINISH****
```
Important: User-created statements can be inserted either before or after the generated statements, but cannot be inserted within the statements generated by TurboIntegrator.