RunProcess function for IBM Planning Analytics (TM1) RunProcess can run multiple processes in parallel. This function can speed up data loads and other processes by dividing work into multiple parts. Each process thread is managed by TM1 Server.  In this video, RunProcess is used to execute the same process, RunProcess_Test, multiple times in parallel with a different year.  Where can…

SubsetGetSize function for IBM Planning Analytics (TM1) SubsetGetSize returns the number of elements in a subset.  In this video, SubsetGetSize will be used to retrieve the size of the ‘All Elements’ subset in the Product Scorecard dimension. Where can the SubsetGetSize function be used? TurboIntegrator Which TM1 Server version is the SubsetGetSize function available for? Version 11…

StringToNumber function for IBM Planning Analytics (TM1) StringToNumber converts a string into a numeric value. In this video, StringToNumber will be used to convert a string variable into a numeric value when exporting to a text file. Where can the StringToNumber function be used? TurboIntegrator Which TM1 Server version is the StringToNumber function available for? Version…

SubsetGetElementName function for IBM Planning Analytics (TM1) SubsetGetElementName retrieves an element’s name from a subset based on an index.  In this video, SubsetGetElementName will be used to retrieve the 2nd positioned element from the ‘All Elements’ subset in the Product Scorecard dimension. Where can the SubsetGetElementName function be used? TurboIntegrator Which TM1 Server version is the SubsetGetElementName function available…

StringToNumberEx function for IBM Planning Analytics (TM1) StringToNumberEx converts a string value into a number based on a specified decimal and the thousand separator. In this video, StringToNumberEx will be used to convert a string variable into a number to 4 decimal places. The decimal character will be set to a full stop, while the thousands operator will be set to a comma.…

SubsetExists function for IBM Planning Analytics (TM1) SubsetExists checks if a public subset exists. The function returns a 1 if the subset exists in the dimension, otherwise it returns 0. In this video, SubsetExists will be used to check if two subsets exist in the Product Scorecard dimension.  Where can the SubsetExists function be used? TurboIntegrator Which…

SetHierarchyElementGroupsSecurity function for IBM Planning Analytics (TM1) SetHierarchyElementGroupsSecurity sets the level of security to an element on a hierarchy to non-admin groups. In the video, SetHierarchyElementGroupsSecurity will be used to set READ access to the ‘No Department’ element from the ‘Department Name’ hierarchy. Where can the SetHierarchyElementGroupsSecurity function be used? TurboIntegrator Which TM1 Server version is the SetHierarchyElementGroupsSecurity…

SubsetExpandAboveSet function for IBM Planning Analytics (TM1) SubsetExpandAboveSet sets expand above a subset. It returns 1 if successful otherwise it returns 0.  In this video, SubsetExpandAboveSet will be used to set Expand Above to the subset, ExpandAbove, in the Quarter dimension. Where can the SubsetExpandAboveSet function be used? TurboIntegrator Which TM1 Server version is the SubsetExpandAboveSet function available…

SubsetAttrSL function for IBM Planning Analytics (TM1) SubsetAttrSL retrieves a string attribute from a subset based on the local language code. If the attribute is not defined for the language code, then the function returns the base attribute value.  In this video, SubsetAttrSL will be used to retrieve the string attribute, Description, from the ‘All Elements’ subset…

SubsetCreate function for IBM Planning Analytics (TM1) SubsetCreate creates a subset in a dimension.  In this video, SubsetCreate will be used to create a permanent and temporary subset in the Product Scorecard dimension.  Where can the SubsetCreate function be used? TurboIntegrator Which TM1 Server version is the SubsetCreate function available for? Version 11 and 12 What is…