IF function for IBM Planning Analytics (TM1) IF uses a conditional expression to check if an expression is true or false.  In this video, IF is used to show how to control which statement is executed based on the Product Scorecard element. Where can the IF function be used? TurboIntegrator Which TM1 Server version is the IF…

HierarchyElementComponentAddDirect function for IBM Planning Analytics (TM1) HierarchyElementComponentAddDirect adds an element to a consolidated element in a hierarchy, rolling up according to the weight defined. 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 HierarchyElementComponentAdd. In the video, HierarchyElementComponentAddDirect will be used to add Netherlands as…

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?…

SecurityRefresh function for IBM Planning Analytics (TM1) SecurityRefresh applies any security changes to the TM1 Server. This function reads all the security control cubes and applies security changes to the TM1 Server.  In the video, SecurityRefresh will be used to apply security changes to the TM1 Server. Where can the SecurityRefresh function be used? TurboIntegrator Which TM1 Server…

NValue function for IBM Planning Analytics (TM1) NValue is a TM1 reserved local variable that determines if the current cell is numeric. In this video, NValue will be used to export data to a file, if it’s numeric. Where can the NValue function be used? TurboIntegrator Which TM1 Server version is the NValue function available…

ODBCClose function for IBM Planning Analytics (TM1) ODBCClose closes an ODBC connection. In this video, ODBCClose will be used to show the impact of using ODBCClose before a query. Where can the ODBCClose function be used? TurboIntegrator Which TM1 Server version is the ODBCClose function available for? Version 11 and 12 What is the syntax for ODBCClose? ODBCClose(DBSource)…

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…