HierarchyElementComponentDeleteDirect function for IBM Planning Analytics (TM1) HierarchyElementComponentDeleteDirect deletes a component (child) from a consolidated element in a specific hierarchy in a dimension. 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 HierarchyElementComponentDelete. In the video, HierarchyElementComponentDeleteDirect will be used to delete Netherlands as a…

ProcessAttrDelete function for IBM Planning Analytics (TM1) ProcessAttrDelete deletes a process attribute.  In this video, ProcessAttrDelete will be used to delete the process attribute, Developers Commentary. Where can the ProcessAttrDelete function be used? TurboIntegrator Which TM1 Server version is the ProcessAttrDelete function available for? Version 11 and 12 What is the syntax for ProcessAttrDelete? ProcessAttrDelete(AttributeName) Relevant Functions

HierarchyElementSecurityPut function for IBM Planning Analytics (TM1) HierarchyElementSecurityPut sets security access for a group to an element. In the video, HierarchyElementSecurityPut will be used to assign READ access to the element, Finance, in the Employee dimension against the Test security group. Where can the HierarchyElementSecurityPut function be used? TurboIntegrator Which TM1 Server version is the HierarchyElementSecurityPut function available for? Version 11 and 12 What…

ProcessAttrN function for IBM Planning Analytics (TM1) ProcessAttrN retrieves data from a numeric attribute for a process.  In this video, ProcessAttrN will be used to retrieve the Reference Number from the TrainingProcess process. Where can the ProcessAttrN function be used? TurboIntegrator Which TM1 Server version is the ProcessAttrN function available for? Version 11 and 12 What is the syntax for…

HierarchyExists function for IBM Planning Analytics (TM1) HierarchyExists checks whether a specific hierarchy exists in a dimension. If the hierarchy exists, the result is 1, and if it does not exist, the result is 0. In the video, HierarchyExists will be used to check whether the United Kingdom hierarchy exists in the Sales Region dimension. Where can the HierarchyExists function be…

HierarchySortOrder function for IBM Planning Analytics (TM1) HierarchySortOrder sets the order in which elements in a dimension are organized and displayed. In the video, HierarchySortOrder will be used to sort the dimension, Region, not Sorted. Where can the HierarchySortOrder function be used? TurboIntegrator Which TM1 Server version is the HierarchySortOrder function available for? Version 11 and…

HierarchyCreate function for IBM Planning Analytics (TM1) HierarchyCreate creates a new hierarchy in a dimension. In the video, HierarchyCreate creates the United Kingdom hierarchy in the dimension of the Sales Region. Where can the HierarchyCreate function be used? TurboIntegrator Which TM1 Server version is the HierarchyCreate function available for? Version 11 What is the syntax…

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

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…