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…

Time function for IBM Planning Analytics (TM1) Time returns the current time from the TM1 server in a string format. In this video, the Time function will be used to retrieve the current TM1 server time.  Where can the Time function be used? Rules and TurboIntegrator Which TM1 Server version is the Time function available…