RuleLoadFromFile function for IBM Planning Analytics (TM1) RuleLoadFromFile loads a text file that contains rules to a Cube In this video, RuleLoadFromFile is used to load a rule from a text file to the Product Scorecard cube. Where can the RuleLoadFromFile function be used? TurboIntegrator Which TM1 Server version is the RuleLoadFromFile function available for? Version 11 and…

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…

ServerActiveSandboxSet function for IBM Planning Analytics (TM1) ServerActiveSandboxSet sets an existing sandbox as active for the user. In this video, ServerActiveSandboxSet will be used to set an active sandbox for the user.  Where can the ServerActiveSandboxSet function be used? TurboIntegrator Which TM1 Server version is the ServerActiveSandboxSet function available for? Version 11 and 12 What is the syntax…

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

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…

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…