DimensionAttrPutS function for IBM Planning Analytics (TM1) DimensionAttrPutS uploads data to a string attribute for a dimension. In this video, DimensionAttrPutS will be used to upload data to the Description attribute from the Employee dimension. Where can the DimensionAttrPutS function be used? TurboIntegrator Which TM1 Server version is the DimensionAttrPutS function available for? Version 11 and 12 What is the…

FormatDate function for IBM Planning Analytics (TM1) FormatDate formats a date value. In this video, FormatDate will be used to return the date value for 18000. Where can the FormatDate function be used? TurboIntegrator Which TM1 Server version is the FormatDate function available for? Version 11 and 12 What is the syntax for FormatDate? FormatDate(Date, Pattern,…

GetProcessErrorFileDirectory function for IBM Planning Analytics (TM1) GetProcessErrorFileDirectory returns the full path name, with a trailing slash, of the directory where error files are written. In this video, GetProcessErrorFileDirectory is used to get the process error file directory. Where can the GetProcessErrorFileDirectory function be used? TurboIntegrator Which TM1 Server version is the GetProcessErrorFileDirectory function available…

GetProcessErrorFileName function for IBM Planning Analytics (TM1) GetProcessErrorFileName returns the name of the error log file associated with the process. If the process has not yet generated an error log file, the function returns an empty (null) string. In this video, GetProcessErrorFileName is used to get the error log file name. Where can the GetProcessErrorFileName function be used?…

GetProcessName function for IBM Planning Analytics (TM1) GetProcessName returns the name of the process. In this video, GetProcessName is used to retrieve the name of the process.  Where can the GetProcessName function be used? TurboIntegrator Which TM1 Server version is the GetProcessName function available for? Version 11 and 12 What is the syntax for GetProcessName? GetProcessName(); Relevant…

HierarchyContainsAllLeaves function for IBM Planning Analytics (TM1) HierarchyContainsAllLeaves validates if a hierarchy contains all leaf elements in the dimension. If all are leaf elements, the function returns 1 (True), and if missing one or more leaf elements, it returns 0 (false). In the video, HierarchyContainsAllLeaves will be used to validate Western Europe hierarchy from the…

ProcessQuit function for IBM Planning Analytics (TM1) ProcessQuit immediately terminates the process and returns a Process Quit message. In this video, ProcessQuit is used to terminate the process and show the error produced immediately. Where can the ProcessQuit function be used? TurboIntegrator Which TM1 Server version is the ProcessQuit function available for? Version 11 and…

PrologMinorErrorCount function for IBM Planning Analytics (TM1) PrologMinorErrorCount is a global variable that counts minor errors that occur in the Prolog. For each minor error encountered, the variable value is incremented by 1. In this video, PrologMinorErrorCount is used to return the number of minor errors encountered in the Prolog when inserting an element to a consolidation that doesn’t exist…

PublishView function for IBM Planning Analytics (TM1)  PublishView publishes a private cube view for everyone to access. In the video, PublishView will be used to publish the Finance view from the Employee cube. Where can the PublishView function be used? TurboIntegrator Which TM1 Server version is the PublishView function available for? Version 11 and 12 What is the syntax…

ServerSandboxListCountGet function for IBM Planning Analytics (TM1) ServerSandboxListCountGet returns the number of sandboxes a user has. In this video, ServerSandboxListCountGet will be used to return the number of sandboxes the user has. Where can the ServerSandboxListCountGet function be used? TurboIntegrator Which TM1 Server version is the ServerSandboxListCountGet function available for? Version 11 and 12 What is the…