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…

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…

HierarchySubsetAttrPutS function for IBM Planning Analytics (TM1) HierarchySubsetAttrPutS writes a string value to a subset’s attribute or set of elements in a hierarchy for a dimension. In this video, HierarchySubsetAttrPutS will be used to put text into an attribute in the default and French language. Where can the HierarchySubsetAttrPutS function be used? TurboIntegrator Which TM1…

HierarchySubsetCreate function for IBM Planning Analytics (TM1) HierarchySubsetCreate creates an empty public subset in a hierarchy. In this video, HierarchySubsetCreate will be used to create the subset, New Created Subset, associated with the Employee hierarchy and Employee dimension. Where can the HierarchySubsetCreate function be used? TurboIntegrator Which TM1 Server version is the HierarchySubsetCreate function available for? Version 11 and 12…

HierarchySubsetDeleteAllElements function for IBM Planning Analytics (TM1) HierarchySubsetDeleteAllElements deletes all elements in a subset from a hierarchy.  In this video, HierarchySubsetDeleteAllElements will be used to delete all elements from the Department subset associated with the Employee hierarchy and Employee dimension. Where can the HierarchySubsetDeleteAllElements function be used? TurboIntegrator Which TM1 Server version is the HierarchySubsetDeleteAllElements function available for? Version 11 and…