Create and edit processes

You can create or edit a TurboIntegrator process in the process editor on a modeling workbench.

Procedure

  1. To create a new process:
    1. Open a modeling workbench.
    2. In the Databases tree, expand the database on which you want to create the new process.
    3. Right-click the Processes group.
    4. Click Create process.
    5. You can change the database where the process is stored by selecting a database from the Database list. The current database is selected by default.
    6. Enter a name for the process.
    7. Click Create.
  2. To edit an existing process:
    1. Open a modeling workbench.
    2. Right-click the process in the Databases tree.
    3. Click Edit process.
  3. Define a data source, set parameters, and enter your process statements in the process editor. Process statements are generally TM1® TurboIntegrator or Rules functions that execute actions upon data or metadata in your database.
    • For full descriptions of all TurboIntegrator functions, see TM1 TurboIntegrator Functions on IBM Knowledge Center.
    • For full descriptions of all Rules functions, see TM1 Rules Functions on IBM Knowledge Center. All Rules functions, with the exceptions of STET and ISLEAF, are valid in TurboIntegrator processes.

    A TurboIntegrator process has four distinct procedures that are executed sequentially when you run a process.

    Procedure 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 must ensure that you create statements in the appropriate procedure within the process. For example, a statement that creates a new cube should be in the Metadata procedure. Similarly, any statements that update data values should be in the Data procedure.

    When you enter a statement within any procedure section in the process editor, it must be either before this line: 

    #****GENERATED STATEMENTS START****

    or after this line:

    #****GENERATED STATEMENTS FINISH****

    Do not insert any of your statements between the generated statements start and finish lines, as anything between these lines can be overwritten.

  4. Click Save to save the process.