ElPar Excel function for IBM Planning Analytics (TM1) ElPar returns the parent of an element in a dimension. In the video, ElPar will be used to return the parents for the element, Bike Racks. Where can the ElPar function be used? Excel, Rules and TurboIntegrator Which TM1 Server version is the ElPar function available for?…

ElParN Excel function for IBM Planning Analytics (TM1) – Excel ElParN returns the number of parents of an element. In the video, ElParN will be demoed in Excel to return the number of parents ‘Bikes’ belongs to, from the Product Type dimension. Please note that the same logic can be used in TurboIntegrator and Excel.…

TM1GlobalSandbox function for IBM Planning Analytics (TM1) TM1GlobalSandbox returns the active sandbox for the user. In this video, TM1GlobalSandbox will be used to get the active sandbox from the AdventureWorks TM1 Server. Where can the TM1GlobalSandbox function be used? Excel Which TM1 Server version is the TM1GlobalSandbox function available for? Version 11 and 12 What…

TM1Info function for IBM Planning Analytics (TM1) TM1Info returns information on the TM1 client. This function is valid only in Planning Analytics for Microsoft Excel and in Planning Analytics websheets. It is not supported in IBM TM1 Perspectives. In this video, TM1Info will be used to get information about the TM1 client. Where can the…

TM1PrimaryDBName function for IBM Planning Analytics (TM1) TM1PrimaryDBName returns the primary TM1 server name in which the user is authenticated. This function is valid only in Planning Analytics for Microsoft Excel and in Planning Analytics websheets. It is not supported in IBM TM1 Perspectives. In this video, TM1PrimaryDBName will be used to obtain the TM1…

ElCompN Excel function for IBM Planning Analytics (TM1) ElWeight returns the number of components under an element. In the video, ElWeight will be used to return the number of components under Accessories. Where can the ElCompN function be used? Excel, Rules and TurboIntegrator Which TM1 Server version is the ElCompN function available for? Version 11…

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…

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…