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…

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…

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…

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…