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

ProcessBreak function for IBM Planning Analytics (TM1) ProcessBreak stops processing any data and moves straight to the Epilog. In this video, ProcessBreak is used to skip all data processing and go straight to the Epilog.  Where can the ProcessBreak function be used? TurboIntegrator Which TM1 Server version is the ProcessBreak function available for? Version 11 and…

ItemSkip function for IBM Planning Analytics (TM1) ItemSkip skips the current transaction in the process. In this video, ItemSkip is used to skip a record for a specific measure. Where can the ItemSkip function be used? TurboIntegrator Which TM1 Server version is the ItemSkip function available for? Version 11 and 12 What is the syntax…

ProcessError function for IBM Planning Analytics (TM1) ProcessError immediately terminates the process and produces an error. In this video, ProcessError is used to terminate the process and show the error produced immediately. Where can the ProcessError function be used? TurboIntegrator Which TM1 Server version is the ProcessError function available for? Version 11 and 12 What…

SetDimensionGroupsSecurity function for IBM Planning Analytics (TM1) SetDimensionGroupsSecurity sets the level of security to a dimension for non-admin groups. In the video, SetDimensionGroupsSecurity will be used to grant WRITE access to the employee dimension to all non-admin groups. Where can the SetDimensionGroupsSecurity function be used? TurboIntegrator Which TM1 Server version is the SetDimensionGroupsSecurity function available for? Version 11 and 12…

SetElementGroupsSecurity function for IBM Planning Analytics (TM1) SetElementGroupsSecurity sets the level of security to an element for non-admin groups. In the video, SetElementGroupsSecurity will be used to grant READ access to the element, ‘Actual’, from the Version dimension. Where can the SetElementGroupsSecurity function be used? TurboIntegrator Which TM1 Server version is the SetElementGroupsSecurity function available for? Version 11 and 12…

SetHierarchyGroupsSecurity function for IBM Planning Analytics (TM1) SetHierarchyGroupsSecurity sets the level of security for a hierarchy to non-admin groups. In the video, SetHierarchyGroupsSecurity will be used to apply READ access to the ‘Department Name’ hierarchy. Where can the SetHierarchyGroupsSecurity function be used? TurboIntegrator Which TM1 Server version is the SetHierarchyGroupsSecurity function available for? Version 11 and 12 What is…

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