HierarchySubsetAliasSet function for IBM Planning Analytics (TM1) HierarchySubsetAliasSet sets an alias for a subset of a hierarchy. Returns 1 if successful or 0 if not. In this video, HierarchySubsetAliasSet will be used to set the alias, Full Name, to the Finance subset in the Employee Hierarchy from the Employee dimension. Where can the HierarchySubsetAliasSet function be used? TurboIntegrator Which TM1 Server version…

HierarchySubsetAttrInsert function for IBM Planning Analytics (TM1) HierarchySubsetAttrInsert adds a new attribute for subsets. In this video, HierarchySubsetAttrInsert will be used to add an Office attribute in the Western Europe hierarchy from the Sales Region dimension. Where can the HierarchySubsetAttrInsert function be used? TurboIntegrator Which TM1 Server version is the HierarchySubsetAttrInsert function available for? Version…

HierarchySubsetAttrSL function for IBM Planning Analytics (TM1) HierarchySubsetAttrSL retrieves data from a string attribute associated with a subset in a hierarchy based on a language locale. In this video, HierarchySubsetAttrSL will be used to retrieve data from the Office attribute in the Benelux subset that’s associated with the Western Europe hierarchy and Sales Region dimension, using the language locale fr. Where can the HierarchySubsetAttrSL function be…

HierarchySubsetElementDelete function for IBM Planning Analytics (TM1) HierarchySubsetElementDelete deletes an element from a subset using an index number. In this video, HierarchySubsetElementDelete will be used to delete the 5th element in the Department subset associated with the Employee hierarchy and Employee dimension. Where can the HierarchySubsetElementDelete function be used? TurboIntegrator Which TM1 Server version is the HierarchySubsetElementDelete function available for? Version 11 and…

HierarchySubsetElementExists function for IBM Planning Analytics (TM1) HierarchySubsetElementExists checks if an elements exists in a public subset. 1 is returned if the elements exists or 0 if it does not exist in the subset. In this video, HierarchySubsetElementExists will be used to check if the element, Finance, exists in the Departments subset that’s associated with the Employee hierarchy and Employee dimension. Where can…

HierarchySubsetElementGetIndex function for IBM Planning Analytics (TM1) HierarchySubsetElementGetIndex returns the index of an element in a subset for a hierarchy. In this video, HierarchySubsetElementGetIndex will be used to return the index for the Finance element in the Departments subset, associated with the Employee hierarchy and Employee dimension, starting from index 1. Where can the HierarchySubsetElementGetIndex function be used? TurboIntegrator Which TM1 Server version is…

HierarchySubsetElementInsert function for IBM Planning Analytics (TM1) HierarchySubsetElementInsert adds an element into a subset associated with a hierarchy. In this video, HierarchySubsetElementInsert will be used to insert Finance into the 5th position in the Departments subset associated with the Employee hierarchy and Employee dimension. Where can the HierarchySubsetElementInsert function be used? TurboIntegrator Which TM1 Server version is the HierarchySubsetElementInsert function available for? Version 11 and…

IF function for IBM Planning Analytics (TM1) IF uses a conditional expression to check if an expression is true or false.  In this video, IF is used to show how to control which statement is executed based on the Product Scorecard element. Where can the IF function be used? TurboIntegrator Which TM1 Server version is the IF…

HierarchyElementComponentAddDirect function for IBM Planning Analytics (TM1) HierarchyElementComponentAddDirect adds an element to a consolidated element in a hierarchy, rolling up according to the weight defined. 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 HierarchyElementComponentAdd. In the video, HierarchyElementComponentAddDirect will be used to add Netherlands as…

ODBCOutput function for IBM Planning Analytics (TM1) ODBCOutput executes an SQL query from TM1 to an ODBC database. Used in conjunction with ODBCOpen. In this video, ODBCOutput will be used to create a connection to the AdventureWorks ODBC connection, and then ODBCOutput will be used to insert a new transaction into the FactSalesQuota table. Where can the ODBCOutput function be…