HierarchyContainsAllLeaves function for IBM Planning Analytics (TM1) HierarchyContainsAllLeaves validates if a hierarchy contains all leaf elements in the dimension. If all are leaf elements, the function returns 1 (True), and if missing one or more leaf elements, it returns 0 (false). In the video, HierarchyContainsAllLeaves will be used to validate Western Europe hierarchy from the…

ProcessQuit function for IBM Planning Analytics (TM1) ProcessQuit immediately terminates the process and returns a Process Quit message. In this video, ProcessQuit is used to terminate the process and show the error produced immediately. Where can the ProcessQuit function be used? TurboIntegrator Which TM1 Server version is the ProcessQuit function available for? Version 11 and…

PrologMinorErrorCount function for IBM Planning Analytics (TM1) PrologMinorErrorCount is a global variable that counts minor errors that occur in the Prolog. For each minor error encountered, the variable value is incremented by 1. In this video, PrologMinorErrorCount is used to return the number of minor errors encountered in the Prolog when inserting an element to a consolidation that doesn’t exist…

PublishView function for IBM Planning Analytics (TM1)  PublishView publishes a private cube view for everyone to access. In the video, PublishView will be used to publish the Finance view from the Employee cube. Where can the PublishView function be used? TurboIntegrator Which TM1 Server version is the PublishView function available for? Version 11 and 12 What is the syntax…

ServerSandboxListCountGet function for IBM Planning Analytics (TM1) ServerSandboxListCountGet returns the number of sandboxes a user has. In this video, ServerSandboxListCountGet will be used to return the number of sandboxes the user has. Where can the ServerSandboxListCountGet function be used? TurboIntegrator Which TM1 Server version is the ServerSandboxListCountGet function available for? Version 11 and 12 What is the…

ServerSandboxMerge function for IBM Planning Analytics (TM1) ServerSandboxMerge merges a source sandbox into a target sandbox for the user who executed the process. In this video, ServerSandboxMerge will be used to merge the sandbox ‘Goal’ to ‘Training’. Where can the ServerSandboxMerge function be used? TurboIntegrator Which TM1 Server version is the ServerSandboxMerge function available for? Version…

SetUseActiveSandboxProperty function for IBM Planning Analytics (TM1) SetUseActiveSandboxProperty sets whether the process reads/writes cube data to the base or active sandbox for the user. In this video, SetUseActiveSandboxProperty will be used to set the sandbox to Goal then Increase and write back to these sandboxes. Where can the SetUseActiveSandboxProperty function be used? TurboIntegrator Which TM1 Server version is the SetUseActiveSandboxProperty…

SubsetAliasSet function for IBM Planning Analytics (TM1) SubsetAliasSet sets the alias attribute in the Subset. In this video, SubsetAliasSet will be used to set the subset, ‘All Elements’, from the Product Scorecard dimension to use the ‘Desc’ alias. Where can the SubsetAliasSet function be used? TurboIntegrator Which TM1 Server version is the SubsetAliasSet function available for? Version…

SubsetAttrN function for IBM Planning Analytics (TM1) SubsetAttrN retrieves a value from a subset’s numeric attribute. In this video, SubsetAttrN will be used to retrieve the numeric attribute, No of Elements, from the ‘All Elements’ subset in the Product Scorecard dimension.  Where can the SubsetAttrN function be used? TurboIntegrator Which TM1 Server version is the SubsetAttrN function available…

SubsetCreateByMDX function for IBM Planning Analytics (TM1) SubsetCreateByMDX creates a public subset based on an MDX statement.  In this video, SubsetCreateByMDX will be used to create a permanent and temporary subset based on an MDX statement from the Product Scorecard dimension. Where can the SubsetCreateByMDX function be used? TurboIntegrator Which TM1 Server version is the…