Editing the Prolog, Metadata, Data, and Epilog Procedures

You can enhance the capabilities of TurboIntegrator by editing the procedures that define the actions of a process. A procedure is a group of statements that manipulates TM1® data or metadata.

A process includes four procedures that are executed in sequence. Each procedure contains generated statements that are created based on the options you select elsewhere in the TurboIntegrator window. You can edit these procedures by adding your own statements that incorporate TurboIntegrator functions and Rules functions.

The procedures contained within a process are:

Tab Description

Prolog

A series of actions to be executed before the data source is processed

Metadata

A series of actions that update or create cube, dimensions, and other metadata structures during processing.

Data

A series of data actions to be executed for each record in the data source.

Epilog

A series of actions to be executed after the data source is processed.

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.

For example, to export processed data to an ASCII file, you would add an ASCIIOutput function to the Data procedure. ASCIIOutput is a function that manipulates data, and it should be executed during processing. Therefore, the Data procedure is the correct location for the function.