tm1export Node Properties (deprecated)

The IBM Cognos TM1 Export node exports data in a format that can be read by Cognos TM1 databases.
Note: This node was deprecated in Modeler 18.0. The replacement node script name is tm1odataexport.
Table 1. tm1export node properties
tm1export node properties Data type Property description
pm_host string
Note: Only for version 16.0 and 17.0
The host name. For example: TM1_export.setPropertyValue("pm_host", 'http://9.191.86.82:9510/pmhub/pm')
tm1_connection ["field","field", ... ,"field"]
Note: Only for version 16.0 and 17.0
A list property containing the connection details for the TM1 server. The format is: [ "TM1_Server_Name", "tm1_ username", "tm1_password"] For example: TM1_export.setPropertyValue("tm1_connection", ['Planning Sample', "admin" "apple"])
selected_cube field The name of the cube to which you are exporting data. For example: TM1_export.setPropertyValue("selected_cube", "plan_BudgetPlan")
spssfield_tm1element_mapping list The tm1 element to be mapped to must be part of the column dimension for selected cube view. The format is: [[[Field_1, Dimension_1, False], [Element_1, Dimension_2, True], ...], [[Field_2, ExistMeasureElement, False], [Field_3, NewMeasureElement, True], ...]] There are 2 lists to describe the mapping information. Mapping a leaf element to a dimension corresponds to example 2 below: Example 1: The first list: ([[Field_1, Dimension_1, False], [Element_1, Dimension_2, True], ...]) is used for the TM1 Dimension map information. Each 3 value list indicates dimension mapping information. The third Boolean value is used to indicate if it selects an element of a dimension. For example: "[Field_1, Dimension_1, False]" means that Field_1 is mapped to Dimension_1; "[Element_1, Dimension_2, True]" means that Element_1 is selected for Dimension_2. Example 2: The second list: ([[Field_2, ExistMeasureElement, False], [Field_3, NewMeasureElement, True], ...]) is used for the TM1 Measure Dimension Element map information. Each 3 value list indicates measure element mapping information. The third Boolean value is used to indicate the need to create a new element. "[Field_2, ExistMeasureElement, False]" means that Field_2 is mapped to the ExistMeasureElement; "[Field_3, NewMeasureElement, True]" means the NewMeasureElement needs to be the measure dimension chosen in selected_measure and that Field_3 is mapped to it.
selected_measure string Specify the measure dimension. Example: setPropertyValue("selected_measure", "Measures")