Order of operations within a TurboIntegrator process

A TurboIntegrator process includes several procedures: Prolog, Metadata, Data, and Epilog. These procedures can be viewed as sub-tabs of the Advanced tab in the TurboIntegrator editor.

When you define a data source, set variables, and specify data actions for a process, TM1® generates scripts that are executed when you run the TurboIntegrator process. These scripts are placed in the appropriate procedure sub-tab of the TurboIntegrator editor. You can also create your own scripts in any of the procedure sub-tabs using TurboIntegrator functions and rules functions.

When you run a TurboIntegrator process, the procedures are executed in the following sequence:

1. The Prolog procedure is executed before the data source for the TurboIntegrator process is opened.
2. If the data source for the process is None, TurboIntegrator immediately executes the Epilog procedure after the Prolog finishes processing.
   Note: When the data source for a process is None, the Metadata and Data procedures are ignored. In this case, all scripts for the process must be created in either the Prolog or Epilog procedures.
3. If the data source is anything other than None, TurboIntegrator opens the data source for the process.
4. All lines in the Metadata procedure are sequentially executed against the first record in the data source. All lines are then sequentially executed against the second record in the data source, and so on until all records are processed.
5. All lines in the Data procedure are sequentially executed against the first record in the data source. All lines are then sequentially executed against the second record in the data source, and so on until all records are processed.
6. TurboIntegrator closes the data source after the Data procedure is completed.
7. The Epilog procedure is executed.
8. TM1 closes the TurboIntegrator process.