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…

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…

HierarchyElementPrincipalName function for IBM Planning Analytics (TM1) HierarchyElementPrincipalName returns the principal name of an element given an alias or the element name itself. In the video, HierarchyElementPrincipalName will be used to retrieve the principal name for an employee. Where can the HierarchyElementPrincipalName function be used? TurboIntegrator Which TM1 Server version is the HierarchyElementPrincipalName function available for? Version…

OnMinorErrorDoItemSkip function for IBM Planning Analytics (TM1) OnMinorErrorDoItemSkip instructs the process to skip to the next record when a minor error is encountered. In this video, OnMinorErrorDoItemSkip will be used to show its impact when a minor error is encountered. Where can the OnMinorErrorDoItemSkip function be used? TurboIntegrator Which TM1 Server version is the OnMinorErrorDoItemSkip function…

HierarchyElementSecurityGet function for IBM Planning Analytics (TM1) HierarchyElementSecurityGet returns the level of security privilege designated to a group for an element. In the video, HierarchyElementSecurityGet will be used to retrieve the security set for the element, Finance, from the Employee dimension for the security group, Test. Where can the HierarchyElementSecurityGet function be used? TurboIntegrator Which TM1 Server version is the…

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…