ElementIndex function for IBM Planning Analytics (TM1) ElementIndex returns the index number of an element within a dimension. In the video, ElementIndex will be used to retrieve the index number of an element of the Employee Hierarchies dimension and apply it in the rule to populate the Employee Salaries cube. Where can the ElementIndex function be used? Rules and…

ElementIsComponent function for IBM Planning Analytics (TM1) ElementIsComponent determines if the element is a child of a consolidation or not. The function returns 1 if the element is a child of consolidation. ​ In the video, ElementIsComponent will be used to determine if an element is a child of consolidation and will be applied in the rule…

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…

ElementParent function for IBM Planning Analytics (TM1) ElementParent returns the parent of an element in the dimension. In the video, ElementParent will be used to return an element’s first parent. The result will be stored in the Employee Salaries cube. Where can the ElementParent function be used? Rules and TurboIntegrator Which TM1 Server version is the…

ElementParentCount function for IBM Planning Analytics (TM1) ElementParentCount returns the number of parents of an element in the dimension. In the video, ElementParentCount will be used to retrieve the number of parents of an element of the Employee Hierarchies dimension and apply it in the rule to populate the Employee Salaries cube. Where can the ElementParentCount…

ElComp Rules function for IBM Planning Analytics (TM1) ElComp returns the name of the child of a consolidated element. In the video, ElComp will be used to retrieve the child’s name from an accessories consolidation and apply it to the rule to populate the Comment measure in the Product Scorecard cube.  Where can the ElComp function be used?…

ElementType function for IBM Planning Analytics (TM1) ElementType returns element type information of an element in the dimension.  In the video, ElementType will be used to retrieve the element type information of an element of the Employee Hierarchies dimension and apply it in the rule to populate the Employee Salaries cube. Where can the ElementType function be…

IsUndefinedCellValue function for IBM Planning Analytics (TM1) IsUndefinedCellValue compares the argument value with the default numeric cube value and returns 1 if the cell value equals the cube’s default value. In this video, IsUndefinedCellValue is used to multiply the Sales Quota Budget values from January by the Monthly Growth in the Sales Assumption cube.  Where can…