ElIsComp Rules function for IBM Planning Analytics (TM1) ElIsComp determines if the element is a child of the consolidation element or not. In the video, ElIsComp will be used to determine if an element is child of  ‘Accessories’ consolidation or not and apply it in the rule to populate the Comment measure in the Product Scorecard…

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

ElIsPar Rules function for IBM Planning Analytics (TM1) ElIsPar determines if an element is the parent of another element or not. In the video, ElIsPar will be used to determine if the ‘All Products by Category’ element is a parent or another element or not and apply it in the rule to populate the Comment…

ElementAttrS function for IBM Planning Analytics (TM1) ElementAttrS deletes an attribute for a dimension. In the video, ElementAttrS will be used to retrieve the Employee Hierarchies dimension string attribute value and apply it in the rule to populate the Employee Salaries cube.​ Where can the ElementAttrS function be used? Rules and TurboIntegrator Which TM1 Server…

Continue function for IBM Planning Analytics (TM1) Continue allows a subsequent rule within the same intersection to be executed. In this video, Continue is used to execute subsequent rules and apply them in the rule to populate the Commission measure in the Product Scorecard cube.  Where can the Continue function be used? Rules and TurboIntegrator…

COS function for IBM Planning Analytics (TM1) COS returns the cosine of an angle expressed in radians. In the video, COS will be used to calculate the cosine of an angle of given radians.  Where can the COS function be used? Rules and TurboIntegrator Which TM1 Server version is the COS function available for? Version 11 and…

CubeAttrN function for IBM Planning Analytics (TM1) CubeAttrN returns a numeric attribute for a specified cube. In the video, CubeAttrN will be used to retrieve the numeric attribute value of the cube and apply it in the rule to populate the Product Scorecard cube.  Where can the CubeAttrN function be used? Rules and TurboIntegrator Which…

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

ElementLevel function for IBM Planning Analytics (TM1) ElementLevel returns the level of an element within a dimension. In the video, ElementLevel will be used to retrieve the element’s level and apply it in the rule to populate the Employee Salaries cube. Where can the ElementLevel function be used? Rules and TurboIntegrator Which TM1 Server version…

ElementNext function for IBM Planning Analytics (TM1) ElementNext returns the element that follows the specified element of a dimension. In the video, ElementNext will be used to retrieve the element’s following element name of the dimension and apply it in the rule to populate the Employee Salaries cube. Where can the ElementNext function be used? Rules…