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…

ServerSandboxExists function for IBM Planning Analytics (TM1) ServerSandboxExists checks if a sandbox exists for a user. It returns a numeric value of 1 if the sandbox exists or 0 if it does not exist. In this video, ServerSandboxExists will be used to check if the sandbox Training exists. Where can the ServerSandboxExists function be used? TurboIntegrator Which TM1…

HierarchySubsetAttrDelete function for IBM Planning Analytics (TM1) HierarchySubsetAttrDelete deletes a subset attribute from a hierarchy in a dimension. In this video, HierarchySubsetAttrDelete will be used to delete Office subset attribute from the Western Europe hierarchy in the Sales Region dimension. Where can the HierarchySubsetAttrDelete function be used? TurboIntegrator Which TM1 Server version is the HierarchySubsetAttrDelete function available for? Version 11 and…

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…

HierarchySubsetDestroy function for IBM Planning Analytics (TM1) HierarchySubsetDestroy destroys a subset from a hierarchy. In this video, HierarchySubsetDestroy will be used to remove the Departments subset associated with the Employee hierarchy and Employee dimension.  Where can the HierarchySubsetDestroy function be used? TurboIntegrator Which TM1 Server version is the HierarchySubsetDestroy function available for? Version 11 and 12 What is the syntax for…

ServerSandboxGet function for IBM Planning Analytics (TM1) ServerSandboxGet returns the name of the active sandbox for the user. If no sandbox is set as active, the function returns a blank string.  In this video, ServerSandboxGet will be used to return the 3rd sandbox for the user running the process. Where can the ServerSandboxGet function be used? TurboIntegrator Which…