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.
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") |