DimensionTopElementInsertDirect function for IBM Planning Analytics (TM1)  DimensionTopElementInsertDirect creates a root element in a dimension by directly editing a dimension. This can only be created if the dimension does not have a standalone root element. 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),…

HierarchyTimeLastUpdated function for IBM Planning Analytics (TM1) HierarchyTimeLastUpdated returns a number that refers to the last time the hierarchy was updated. This is a consecutive number that counts the days since 01/01/1900.  In the video, HierarchyTimeLastUpdated will be used to retrieve the date number when the Employee Hierarchies’ hierarchy and ‘Employee Hierarchies’ dimension was last updated. Where can the HierarchyTimeLastUpdated function…

HierarchyHasOrphanedLeaves function for IBM Planning Analytics (TM1) HierarchyHasOrphanedLeaves returns 1 if a hierarchy in a dimension has an orphaned element or returns 0 if there is no orphaned element in that hierarchy. In the video, HierarchyHasOrphanedLeaves will be used to see if there are any orphaned elements in the Employee Hierarchies dimension. Where can the HierarchyHasOrphanedLeaves function be used? TurboIntegrator…

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…