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…

ElPar Rules function for IBM Planning Analytics (TM1) ElPar returns the parent of an element. In the video, ElPar will be used to retrieve an element’s parent name and apply it in the rule to populate in the Product Scorecard cube. Where can the ElPar function be used? Excel, Rules and TurboIntegrator Which TM1 Server version is…

ElParN Rules function for IBM Planning Analytics (TM1) ElParN returns the number of parents of an element. In the video, ElParN will be demoed in a Rule, but you can also use the same logic in TurboIntegrator and Excel. For the video demo in Excel, head here. ELPAR could be used in conjunction with ElParN…

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…

IF Rules function for IBM Planning Analytics (TM1) IF is a logical expression function that evaluates multiple logical expressions. In this video, IF will be used to evaluate the logical expression and apply it in the rule to populate the Commission measure in the Product Scorecard cube.  Where can the IF function be used? Rules and TurboIntegrator…

Insrt function for IBM Planning Analytics (TM1) Insrt inserts one string into another string at the given position number. In this video, Insrt will be used to insert a string into another string and apply it in the rule to populate the Comment measure in the Product Scorecard cube.  Where can the Insrt function be used? Rules and TurboIntegrator…

IsLeaf function for IBM Planning Analytics (TM1) IsLeaf determines if an element is a leaf element or not. In this video, IsLeaf is used to check if an element is a leaf element or not and apply it in the rule to populate the Product Scorecard cube. Where can the IsLeaf function be used? Rules…

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