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…

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…

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…

ElWeight Rules function for IBM Planning Analytics (TM1) ElWeight returns the weight of a child element. In the video, ElWeight will be used to retrieve weight of a child element of a consolidation and apply it in the rule to populate in the Product Scorecard cube.​ Where can the ElWeight function be used? Excel, Rules and…

FEEDERS function for IBM Planning Analytics (TM1) FEEDERS flags rule cells and forces the TM1 engine to calculate. To become proficient with feeders, these resources are useful: learn how feeders work, how to find over feeding, troubleshooting feeders and mastering conditional feeders. In this video, FEEDERS will be used to feed rule-calculated cells and apply them…

HierarchyIndex function for IBM Planning Analytics (TM1) HierarchyIndex returns a 1-based index if the hierarchy is in the supplied dimension, 0 otherwise. In this video, HierarchyIndex will be used to retrieve the dimension hierarchy index value and apply it in the rule to populate the Employee Salaries cube.​ Where can the HierarchyIndex function be used?…

HierarchyN function for IBM Planning Analytics (TM1) HierarchyN returns the name of the hierarchy at a specified position. In this video, HierarchyN will be used to retrieve Employee Hierarchies dimension hierarchies name and apply it in the rule to populate in the Employee Salaries cube. Where can the HierarchyN function be used? Rules Which TM1 Server version is…