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…

WildCardFileSearch function for IBM Planning Analytics (TM1) WildCardFileSearch searches files using wildcard characters in a folder. In this video, WildCardFileSearch is used to search files starting with a P. Where can the WildCardFileSearch function be used? TurboIntegrator Which TM1 Server version is the WildCardFileSearch function available for? Version 11 and 12 What is the syntax…

ElementComponent function for IBM Planning Analytics (TM1) ElementComponent returns the name of the child of a consolidated element. In the video, ElementComponent will be used to retrieve a child’s name from a consolidated element of the Employee Hierarchies dimension and apply it in the rule to populate the TestS measure in the Employee Salaries cube. Where can the ElementComponent…

ElementComponentCount function for IBM Planning Analytics (TM1) ElementComponentCount returns the number of consolidation components. In the video, ElementComponentCount will be used to determine the number of elements of the consolidation of the Employee Hierarchies dimension and apply it in the rule to populate the Employee Salaries cube. Where can the ElementComponentCount function be used? Rules and…

ElementCount function for IBM Planning Analytics (TM1) ElementCount returns the number of components of the consolidated element. In the video, ElementCount will be used to return the number of elements from the Employee Hierarchy dimension. Where can the ElementCount function be used? Rules and TurboIntegrator Which TM1 Server version is the ElementCount function available for?…

ElementFirst function for IBM Planning Analytics (TM1) ElementFirst returns the first element of a specified dimension. In the video, ElementFirst will be used to retrieve the first element of the Employee Hierarchies dimension and apply it in the rule to populate in the Employee Salaries cube.​ Where can the ElementFirst function be used? Rules and TurboIntegrator Which…

ElementIsAncestor function for IBM Planning Analytics (TM1) ElementIsAncestor determines if the element is an ancestor of another element or not. In the video, ElementIsAncestor will be used to determine if the consolidation element is an ancestor of another element or not and apply it in the rule to populate the Comment measure in the Employee Salaries…