TurboIntegrator Editor:

The TurboIntegrator Editor lets you define processes for importing data or metadata from several possible sources. The editor is comprised of five tabs, several of which are dynamic or contain sub-tabs. You define a process by completing each tab in sequential order.

File Menu:

Menu Item	Description
Save	Saves the current process definition.
Save As	Saves the current process definition with a new name.
Run	Runs the current process.
Exit	Closes the TurboIntegrator Editor.

Edit Menu:

Menu Item	Description
Undo	Undoes the last typing action that was performed on the Prolog, Metadata, Data, or Epilog procedure sub-tab.
Cut	Cuts the selected text to the Clipboard.
Copy	Copies the selected text to the Clipboard.
Paste	Pastes the contents of the Clipboard to the current field or cell.

Tabs:

• Data Source Tab
• Variables Tab
• Maps Tab
• Advanced Tab
• Schedule Tab

Data source Tab:
Use the Data Source tab to identify and access the source from which you want to import data.

Note: When defining a process from a TM1 client, the path to an ASCII or ODBC data source may differ from the path used by the server. If this happens, the process will fail. To ensure that your processes work correctly:

• Define processes involving ODBC data sources on the actual TM1 server where the process is to reside. Do not use a remote client to define such a process.
• Use the Windows Network Neighborhood to define the path to ASCII data sources. This ensures that the path is unambiguous to both clients and servers.

The fields and options available on the Data Source tab vary according to the Datasource Type you select. The following table describes the required fields and options for each source.

Datasource Type	Required Fields and Options	Description
ODBC	Data Source Name	The full path to the ODBC data source.
	UserName	Your user name on the source.
	Password	Your password.
	Query	An SQL query to extract data from the source.
ASCII	Data Source Name	The full path to the source ASCII file. To ensure that this path is recognizable to both client and server, click the Browse button and use the Network Neighborhood to define the path.
	Data Source Name On Server	When you create a new process, TurboIntegrator assumes that the data source name on the TM1 server is identical to the data source name used to create the process. If the data source name on the server is different from the local data source used to create the process, enter the full path to the data source file on the server.
	Delimiter Type	Select the method the source uses to separate columns, either Delimited or Fixed Width.
	Delimiter	This option becomes available when you select a Delimited type. Specify the character used to delimit columns in the data source.
ASCII (cont.)	Set Field Width	This button becomes available when you select a Fixed Width type. Click the button, then use the Data Preview dialog box to set column widths.
	Quote Char	Specify the quote character used in your source data.

Example Grid:
The example grid displays the first ten records in your data source. Use this grid to confirm that the source is correct and to help determine the structure of records.
If you change your data source, click Update to refresh the display of the grid.

Variables Tab:
The Variables tab includes a grid and two buttons.

Grid:
Use the Variables grid to assign variables and identify the contents of each column in your data source. The Variables grid includes the following columns.

Column	Description
Column ID	Lists each unique field or column identified in your data source. Cells in this column cannot be edited.
Variable Name	Contains an automatically generated variable for each column in your data source. All generated variables are named Vn, where n is 0 for the first column and is incremented by 1 for each subsequent column in the source. To assign a different variable, click the appropriate cell and enter the new variable.
Variable Type	Contains a drop-down list for each column in your data source. Use the list to specify whether a variable is string or numeric.
Sample Value	Contains sample values from the first record of your source. These sample values help you identify the contents of each column of your source. Cells in the Sample Value column cannot be edited.
Contents	Contains a drop-down list for each column in your data source. Use the list to specify the type of value contained in each column of your source.
Formula	This column is grayed-out for all fields in your source, and becomes available only when you create a new variable. When you create a new variable, double-click the associated Formula cell to open the Process Variable Formula dialog box, from which you can define a formula for the variable.

Buttons:

Button	Description
New variable	Click to create a new variable.
Delete	Click to delete a user-created variable.

Maps Tab:
Use the Maps tab to specify how source data maps to cubes, dimensions, data, consolidations, and attributes in the TM1 database.

The Maps tab consists of a series of sub-tabs, each containing options that let you map variables for your source data to existing TM1 metadata structures. The sub-tabs that are available vary according to the type of values contained in your source data, as specified in the Contents column of the Variables tab.

The Maps tab contains the following sub-tabs.

Cube:
Use the Cube sub-tab to specify how TurboIntegrator maps imported data to TM1 cubes. The Cube sub-tab includes the following options.

Option	Description
Cube Action	Select an option to create, update, recreate, or apply no action to a cube.
Cube Name	Specify the cube to which the action applies. If creating a new cube, type the cube name in the entry field. Otherwise, select an existing cube from the drop-down list.
Zero Out Portion	This option becomes available when you select the Update Cube action. Select this box if you want to set all data points in a cube view to zero.
View Name	This option becomes available when you select the Update Cube and Zero Out Portion options. Select or define the view that encompasses the data points you want to zero out.
Data Action	Select an option that determines how processed data is stored in the cube. Store Values overwrites existing cube values with values imported by the process. Accumulate Values adds values imported by the process to existing cube values.
Enable Cube Logging	Fill this check box to write cube changes to the Tm1s.log file. Clear this box to process cubes without recording changes in Tm1s.log.

Dimensions:
Use the Dimensions sub-tab to map element variables to dimension elements.

The sub-tab includes a grid you use to map individual variables to dimensions in the TM1 database. The grid includes the following columns.

Column	Description
Element Variable	Contains the name of each variable for which you specified a Contents value of Element. The Contents value is specified in the Variables tab. This column also contains the label (Data Variables) for any variables with a Contents value of Data.
Sample Value	A sample value from the first record of your data source. Use this value to help identify the dimension to which the element variable maps.
Dimension	Contains a drop-down list of all dimensions available on the server. Select the dimension to which the element variable maps. To map the element variable to a new dimension, type the new dimension name in the entry field.
Order in Cube	This option becomes available when the Cube Action is Create. Use the drop-down list to specify the order of each dimension in the cube you are creating.
Action	Contains a drop-down list of available dimension actions. Select an action. To create a new dimension, you must specify an action of Create.
Element Type	Select an element type for the variable, either Numeric or String.
Element Order	Select an option for ordering elements in any dimensions you are creating or updating. There are four sort orders: Input - Sorts elements in the order they are created in the dimension. Name - Sorts elements in alphabetical order, either ascending or descending. Level - Sorts elements by hierarchy level, either ascending or descending. Hierarchy - Sorts elements as they exist in the dimension hierarchy.

Data:
Use the Data sub-tab to map data variables to specific elements.

The sub-tab includes a grid you use to map individual variables to elements in the TM1 database. The grid includes the following columns.

Column	Description
Data Variable	Contains the name of each variable for which you specified a Contents value of Data. The Contents value is specified in the Variables tab.
Element	Click the right arrow button to open the Subset Editor, where you can choose the element to which the variable maps. To map the variable to a new element, type the element name in the entry field.
Element Type	Click the drop-down list to select an element type.
Sample Value	A sample value from the first record of your data source. Use this value to help identify the element to which the data variable maps.

Consolidations:
Use the Consolidations sub-tab to map children to consolidated elements.

The sub-tab includes a grid you use to map individual variables to dimensions in the TM1 database. The grid includes the following columns.

Column	Description
Cons. Variable	Contains the name of each variable for which you specified a Contents value of Consolidation. The Contents value is specified in the Variables tab.
Dimension	Contains a drop-down list of dimensions to which the consolidation can map.
Child Variable	Contains a list of variables from which you select the immediate child of the consolidation.
Weight	Assigns a weight to the specified child variable.
Sample Value	A sample value from the first record of your data source. Use this value to help identify the element to which the consolidation maps.

Attributes:
Use the Attributes sub-tab to map attribute variables to specific attributes.

The sub-tab includes a grid you use to map individual variables to dimensions in the TM1 database. The grid includes the following columns.

Column	Description
Attribute Variable	Contains the name of each variable for which you specified a Contents value of Attribute. The Contents value is specified in the Variables tab.
Sample Value	Displays a sample value from the data source. Use this sample to help map the attribute.
Dimension	Contains a drop-down list of all dimensions available on the server. Select the dimension to which the attribute applies.
Element Variable	Contains a drop-down list of element variables. Select the variable for the element to which the attribute variable applies.
Attribute	Contains a drop-down list of attributes to which the variable can map. Select the appropriate attribute from this list.
Action	Choose to either Create a new attribute or Update an existing one.
Attribute Type	Identifies the type of attribute selected in the Attribute column.

Advanced Tab:
The Advanced tab contains several sub-tabs that display statements generated by TM1 based on the options you select elsewhere in the TurboIntegrator Editor. The Advanced tab also includes a sub-tab where you can define parameters for the process.

Parameters:

Item	Description
Insert	Click to insert a new parameter.
Delete	Click to delete a selected parameter.
Parameter Column	Type a name for each new parameter.
Type Column	For each parameter, select a type from the drop-down list.

Prolog:

Item	Description
Statement text box	Displays generated statements that define a series of actions to be executed before the data source is processed. You can enhance a process by creating additional statements with rules or TurboIntegrator functions.
Goto Line button	Click this button, enter the line you want to go to, then click OK to go directly to a line of code in the statement text box.

Metadata:

Item	Description
Statement text box	Displays generated statements that define a series of actions to be executed on TM1 metadata before the data source is processed. You can enhance a process by creating additional statements with rules or TurboIntegrator functions.
Goto Line button	Click this button, enter the line you want to go to, then click OK to go directly to a line of code in the statement text box.

Data:

Item	Description
Statement text box	Displays generated statements that define a series of actions to be executed when the data source is processed. You can enhance a process by creating additional statements with rules or TurboIntegrator functions.
Goto Line button	Click this button, enter the line you want to go to, then click OK to go directly to a line of code in the statement text box.

Epilog:

Item	Description
Statement text box	Displays generated statements that define a series of actions to be executed after the data source is processed. You can enhance a process by creating additional statements with rules or TurboIntegrator functions.
Goto Line button	Click this button, enter the line you want to go to, then click OK to go directly to a line of code in the statement text box.

Schedule Tab:
Use this tab to schedule a process to execute at regular intervals

Item	Description
Schedule this Process as a Chore Named	Fill this check box to enable the process to be executed as a chore at regular intervals. By default, the chore bears the same name as the process. If you want to assign the chore a different name, type it in the entry field.
Chore Start Date and Time	Select a start date on the calendar and specify a start time in the Time field.
Chore Execution Frequency	Fill the appropriate fields to establish the interval at which the chore should be executed.