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…

ViewDestroy function for IBM Planning Analytics (TM1)  ViewDestroy deletes a cube view. In the video, ViewDestroy will be used to delete the view, My Reporting View, from the Sales Quota cube.  Where can the ViewDestroy function be used? TurboIntegrator Which TM1 Server version is the ViewDestroy function available for? Version 11 and 12 What is the syntax for ViewDestroy? ViewDestroy(CubeName, ViewName)…

ViewTitleElementSet function for IBM Planning Analytics (TM1)  ViewTitleElementSet sets an element to a dimension in the title position for a cube view. In the video, ViewTitleElementSet will be used to set the element 2020 to the year dimension that is positioned in the title position for the Sales Quota cube default view. Where can the…

ViewZeroOut function for IBM Planning Analytics (TM1)  ViewZeroOut clears all the data for a cube view.  In the video, ViewZeroOut will be used to clear My Budget Assumptions view from the Planning Assumptions cube.  Where can the ViewZeroOut function be used? TurboIntegrator Which TM1 Server version is the ViewZeroOut function available for? Version 11 and 12 What is the…

While function for IBM Planning Analytics (TM1) While repeats a set of commands until a condition is true. In this video, While is used to go through all the elements in the Product Scorecard dimension. Where can the While function be used? TurboIntegrator Which TM1 Server version is the While function available for? Version 11 and 12 What is…