ItemReject function for IBM Planning Analytics (TM1) ItemReject skips the current source data transaction like ItemSkip. However, ItemReject allows us to write a custom message in the log file. In this video, ItemReject is used to output an error message for a specific measure. Where can the ItemReject function be used? TurboIntegrator Which TM1 Server version is the ItemReject…

HierarchyElementComponentDelete function for IBM Planning Analytics (TM1) HierarchyElementComponentDelete deletes a component (child) from a consolidated element in a hierarchy. This action occurs after a commitment in the process (e.g. at the end of executing the metadata tab). To action this function immediately, use HierarchyElementComponentDeleteDirect. In the video, HierarchyElementComponentDelete will be used to delete Netherlands as a child of Benelux in the Western Europe hierarchy…

ODBCOutput function for IBM Planning Analytics (TM1) ODBCOutput executes an SQL query from TM1 to an ODBC database. Used in conjunction with ODBCOpen. In this video, ODBCOutput will be used to create a connection to the AdventureWorks ODBC connection, and then ODBCOutput will be used to insert a new transaction into the FactSalesQuota table. Where can the ODBCOutput function be…

ParseDate function for IBM Planning Analytics (TM1) ParseDate parses a date string according to a format defined with the NewDateFormatter function.  In this video, ParseDate will be used to parse the date ‘2020-04-22’, according to the format ‘yyyy-MM-dd’. Where can the ParseDate function be used? TurboIntegrator Which TM1 Server version is the ParseDate function available for? Version 11…

ProcessAttrInsert function for IBM Planning Analytics (TM1) ProcessAttrInsert creates a process attribute.  In this video, ProcessAttrInsert will be used to create the process attribute, Description Where can the ProcessAttrInsert function be used? TurboIntegrator Which TM1 Server version is the ProcessAttrInsert function available for? Version 11 and 12 What is the syntax for ProcessAttrInsert? ProcessAttrInsert( PreviousAttributeName, NewAttributeName, AttributeType) Relevant Functions

ProcessAttrPutN function for IBM Planning Analytics (TM1) ProcessAttrPutN uploads data to a numeric attribute for a process. In this video, ProcessAttrPutN will be used to upload 42 to the Reference Number attribute, against the TrainingProcess process. Where can the ProcessAttrPutN function be used? TurboIntegrator Which TM1 Server version is the ProcessAttrPutN function available for? Version 11 and 12 What is the syntax for…

ProcessAttrPutS function for IBM Planning Analytics (TM1) ProcessAttrPutS upload to a string attribute for a process. In this video, ProcessAttrPutS will be used to upload data to the Description attribute, against the TrainingProcess process. Where can the ProcessAttrPutS function be used? TurboIntegrator Which TM1 Server version is the ProcessAttrPutSlete function available for? Version 11 and 12 What is the syntax…

ElementAttrDelete function for IBM Planning Analytics (TM1) ElementAttrDelete deletes attribute for a dimension. In the video, ElementAttrDelete will be used to delete the attribute, zTemp, from the Product Type dimension. Where can the ElementAttrDelete function be used? TurboIntegrator Which TM1 Server version is the ElementAttrDelete function available for? Version 11 and 12 What is the syntax for ElementAttrDelete?…

HierarchyTopElementInsertDirect function for IBM Planning Analytics (TM1) HierarchyTopElementInsertDirect adds a root element to the target hierarchy if there isn’t any root element. This function is actioned immediately.  To action this function until the process makes a commitment (e.g. at the end of executing the metadata tab), use ​HierarchyTopElementInsert. In the video, HierarchyTopElementInsertDirect will be used to insert the…

ElementAttrInsert function for IBM Planning Analytics (TM1) ElementAttrInsert creates an attribute for a dimension. In the video, ElementAttrInsert will be used to create an attribute, zTemp, into the Product Type dimension after the attribute Active Status. Where can the ElementAttrInsert function be used? TurboIntegrator Which TM1 Server version is the ElementAttrInsert function available for? Version 11 and 12 What is…