HierarchyDeleteElements function for IBM Planning Analytics (TM1) HierarchyDeleteElements deletes an element from a hierarchy. In the video, HierarchyDeleteElements will be used to delete Hungary and Poland from the Sales Region hierarchy in the Sales Region dimension. Where can the HierarchyDeleteElements function be used? TurboIntegrator Which TM1 Server version is the HierarchyDeleteElements function available for? Version…

HierarchyDestroy function for IBM Planning Analytics (TM1) HierarchyDestroy deletes a hierarchy from a dimension. In the video, HierarchyDestroy will be used to delete the United Kingdom hierarchy from the Sales Region dimension Where can the HierarchyDestroy function be used? TurboIntegrator Which TM1 Server version is the HierarchyDestroy function available for? Version 11 and 12 What is the syntax for…

HierarchyElementComponentAdd function for IBM Planning Analytics (TM1) HierarchyElementComponentAdd adds an element to a consolidated element in a hierarchy, rolling up according to the weight defined. This action occurs after a commitment in the process (e.g. at the end of executing the metadata tab). To action this function immediately, use HierarchyElementComponentAddDirect. In the video, HierarchyElementComponentAdd will be used to add Netherlands as a…

HierarchySubsetGetElementName function for IBM Planning Analytics (TM1) HierarchySubsetGetElementName returns the name of an element from a subset using an index number associated with a hierarchy. In this video, HierarchySubsetGetElementName will be used to retrieve the 5th element from the Departments subset that’s associated with the Employee hierarchy and Employee dimension. Where can the HierarchySubsetGetElementName function be used? TurboIntegrator Which TM1 Server version is the…

HierarchySubsetIsAllSet function for IBM Planning Analytics (TM1) HierarchySubsetIsAllSet sets a subset to contain all elements of the dimension.​Flag: If 0, the subset will be static and contain the elements by the time the process is executed. If different from zero, the subset will always be updated with all elements  In this video, HierarchySubsetIsAllSet will be used…

HierarchySubsetMDXGet function for IBM Planning Analytics (TM1) HierarchySubsetMDXGet returns the MDX expression used for a subset associated with a hierarchy. In this video, HierarchySubsetMDXGet will be used to retrieve the MDX expression for the Department subset that’s associated with the Employee hierarchy and Employee dimension. Where can the HierarchySubsetMDXGet function be used? TurboIntegrator Which TM1 Server version is the HierarchySubsetMDXGet function…

HierarchyTopElementInsert function for IBM Planning Analytics (TM1) HierarchyTopElementInsert adds a root element to a hierarchy if there isn’t any root element. This action occurs after a commitment to the process (e.g., at the end of executing the metadata tab). To action this function immediately, use HierarchyTopElementInsertDirect. In the video, HierarchyTopElementInsert will be used to insert the element, Total…

LogOutput function for IBM Planning Analytics (TM1) LogOutput writes a message to the tm1server.log file.  In this video, LogOutput is used to write a message in the tm1server.log file and show different severity levels.  Where can the LogOutput function be used? TurboIntegrator Which TM1 Server version is the LogOutput function available for? Version 11 and…

HierarchyElementInsertDirect function for IBM Planning Analytics (TM1) HierarchyElementInsertDirect adds an element to a specific hierarchy. 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 HierarchyElementInsert. In the video, HierarchyElementInsertDirect will be used to add Scotland as a numeric element, positioned before Wales, in the United Kingdom hierarchy from…

ODBCOpen function for IBM Planning Analytics (TM1) ODBCOpen opens a connection between TM1 to an ODBC database. In this video, ODBCOpen will be used to create a connection to the AdventureWorks ODBC connection, then ODBCOutput will be used to insert a new transaction into the FactSalesQuota table. Where can the ODBCOpen function be used? TurboIntegrator Which TM1 Server version…