ElIsComp Excel function for IBM Planning Analytics (TM1) ElIsComp determines whether an element is a component of a parent element in a dimension. In the video, ElIsComp will be used to delete the file ‘Price and Cost.csv’ in Excel. Where can the ElIsComp function be used? Excel, Rules and TurboIntegrator Which TM1 Server version is the…

ElIsPar Excel function for IBM Planning Analytics (TM1) ElWeight determines whether an element is a parent of a child in a dimension. In the video, ElWeight will be used to determine if Bikes is Mountain Bikes’s parent. Where can the ElIsPar function be used? Excel, Rules and TurboIntegrator Which TM1 Server version is the ElIsPar…

TM1User function for IBM Planning Analytics (TM1) TM1User returns the user logged in. In this video, TM1User will be used to see who is logged in for the TM1 server, AdventureWorks. Where can the TM1User function be used? Excel and TurboIntegrator Which TM1 Server version is the TM1User function available for? Version 11 and 12…

ElSLen Excel function for IBM Planning Analytics (TM1) ElSLen returns the number of characters in the element in a dimension. Member ID and alias can be used. In the video, ElSLen will be used to return the character length for elements from the Product Type dimension. Where can the ElSLen function be used? Excel, Rules…

ElWeight Excel function for IBM Planning Analytics (TM1) ElWeight returns the element’s weight to a consolidated element in a dimension. In the video, ElWeight will be used to delete the file ‘Price and Cost.csv’ in Excel. Where can the ElWeight function be used? Excel, Rules and TurboIntegrator Which TM1 Server version is the ElWeight function available…

ElementName function for IBM Planning Analytics (TM1) ElementName returns the element of a dimension based on the index argument. In the video, ElementName will be used to retrieve the name of an element of the Employee Hierarchies dimension and apply it in the rule to populate in the Employee Salaries cube. Where can the ElementName…

TabDim function for IBM Planning Analytics (TM1) TabDim returns the dimension name in a cube based on an index. In this video, TabDim will be used to obtain the dimensions from the Product Scorecard cube. Where can the TabDim function be used? Excel, Rules and TurboIntegrator Which TM1 Server version is the TabDim function available…

LevelCount function for IBM Planning Analytics (TM1) LevelCount returns the number of levels within a dimension. Where can the LevelCount function be used? Rules and TurboIntegrator Which TM1 Server version is the LevelCount function available for? Version 11 and 12 What is the syntax for LevelCount? LevelCount(dimension, hierarchy) Relevant Functions

NumericGlobalVariable function for IBM Planning Analytics (TM1) NumericGlobalVariable declares a numeric global variable that is recognised by other processes within a Chore or from sub-processes called by the ExecuteProcess function. Where can the NumericGlobalVariable function be used? TurboIntegrator Which TM1 Server version is the NumericGlobalVariable function available for? Version 11 and 12 What is the…

StringGlobalVariable function for IBM Planning Analytics (TM1) StringGlobalVariable declares a string global variable that is recognised by other processes within a Chore or from sub-processes called by the ExecuteProcess function. In this video, StringGlobalVariable will be used to declare a string global variable, sGlobalVariable, and show that the variable can be accessed from processes that are called…