SubsetAttrPutN function for IBM Planning Analytics (TM1) SubsetAttrPutN updates a numeric attribute from a subset. In this video, SubsetAttrPutN will be used to update the numeric attribute, No of Elements, from the ‘All Elements’ subset in the Product Scorecard dimension. Where can the SubsetAttrPutN function be used? TurboIntegrator Which TM1 Server version is the SubsetAttrPutN function available for?…

DimensionElementInsertDirect  function for IBM Planning Analytics (TM1)  DimensionElementInsertDirect adds an element in a dimension by directly editing a dimension. This function is actioned immediately.  To action this function until the process makes a commitment (e.g. at the end of executing the metadata tab), use DimensionElementInsert. In the video, the DimensionElementInsertDirect will be used to create a dimension called ‘A New Dimension’.…

DBRW function for IBM Planning Analytics (TM1) The DBRW serves as a fundamental tool for interacting with multidimensional data cubes on IBM Planning Analytics (TM1), enabling precise retrieval and modification of data within the context of financial planning, analysis and reporting. This function is used directly in Excel, enabling users to create dynamic and interactive…

ElLev Excel function for IBM Planning Analytics (TM1) ElLev returns an element’s level in the dimension. In the video, ElLev will be used to return the consolidation and the descendants of All Products by Category and show each element’s level. Where can the ElLev function be used? Excel, Rules and TurboIntegrator Which TM1 Server version…

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…