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…

MetadataMinorErrorCount function for IBM Planning Analytics (TM1) MetadataMinorErrorCount is a global variable that counts minor errors occurring in a process’s Metadata portion. For each minor error encountered, the variable value is incremented by 1. In this video, MetadataMinorErrorCount is used to return the number of minor errors encountered from Metadata procedure lines when adding an element to a consolidation that…

ProcessReturnCode function for IBM Planning Analytics (TM1) ProcessReturnCode is a global variable that stores the status of the most recently executed process. In this video, ProcessReturnCode is used to determine if it ran normally or not. Where can the ProcessReturnCode function be used? TurboIntegrator Which TM1 Server version is the ProcessReturnCode function available for? Version…

MinorErrorLogMax function for IBM Planning Analytics (TM1) MinorErrorLogMax sets the maximum number of minor errors written in the TM1 process error log file. In this video, MinorErrorLogMax will be used to change the maximum number of minor errors written in TM1 process error log from 1000 to 100 lines.  Where can the MinorErrorLogMax function be used?…

ProcessRollBack function for IBM Planning Analytics (TM1) ProcessRollBack terminates the process and begins a rollback. ProcessRollback cancels all pending edits and terminates the process with an error message.  In this video, ProcessRollBack is used to terminate the process show what happens when a rollback occurs. Where can the ProcessRollBack function be used? TurboIntegrator Which TM1 Server version is the…

NewDateFormatter function for IBM Planning Analytics (TM1) NewDateFormatter sets the date format used with ParseDate and FormatDate function. In this video, NewDateFormatter will be used to get today’s date and time and convert it to Chicago and Melbourne time. Where can the NewDateFormatter function be used? TurboIntegrator Which TM1 Server version is the NewDateFormatter function available for?…