Using the process editor

The process editor allows you to modify procedures that were defined when a process was created.

When to use the process editor

Use the process editor when you want to do the following actions:

  • refine the process that is generated when you run a Guided Import
  • create a script only process
  • bypass the Guided Import
  • create a process without executing it right away

Comparing the process editor with the TurboIntegrator editor

The process editor has a toolbar that allows you to perform many useful editing tasks. For example, click the comment/uncomment icon comment/uncomment icon to comment out selected text. Or you can click the content assist icon content assist icon to see a list of valid functions.

In IBM® Cognos® TM1® Performance Modeler, process editor scripts contain both a generated header and generated statements. TurboIntegrator scripts contain generated statements, but not a generated header.

Some process editor commands do not exist in TurboIntegrator. For example, in the process editor you can create collapsible content by enclosing text between the following two lines:

#Region region_name
#EndRegion

The following data types are supported in IBM Cognos TM1 Architect, but not supported in Cognos TM1 Performance Modeler:

  • ODBO
  • SAP
  • IBM Cognos packages

Moving scripts between Cognos TM1 Performance Modeler and Cognos TM1 Architect

Process editor scripts and TurboIntegrator scripts have similar formats, but are not completely interchangeable. You can share scripts between both editors as long as you don't change the mappings. The following table lists three scenarios where scripts are moved between Cognos TM1 Performance Modeler and IBM Cognos TM1 Architect. The script remains valid in the first two scenarios. But in the third scenario, the mappings are modified, which makes the script invalid.

Scenario Validity of script
Script created in Cognos TM1 Architect and opened in Cognos TM1 Performance Modeler. Valid
Script created in Cognos TM1 Performance Modeler and opened in Cognos TM1 Architect. Valid
Script created in Cognos TM1 Performance Modeler, modified in Cognos TM1 Architect, and opened in Cognos TM1 Performance Modeler. Not valid.

Example: the ViewZeroOut function

The ViewZeroOut function sets all data points in a view to zero. Syntax:

ViewZeroOut(Cube, ViewName);.
Argument Description
Cube The parent cube of the view you want to zero out.
ViewName The view you want to zero out. 
ViewZeroOut('99sales', '1st Quarter Actuals');

This example sets all data points in the 1st Quarter Actuals view to zero.