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…

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…