-
ElementParentCount function for IBM Planning Analytics (TM1)
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 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 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 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 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…
-
LOG function for IBM Planning Analytics (TM1)
LOG function for IBM Planning Analytics (TM1) LOG returns the base 10 logarithm of a positive number. In the video, LOG will be used to calculate the base 10 logarithm of positive value and apply it in the rule to populate the Product Scorecard cube. Where can the LOG function be used? Rules and TurboIntegrator Which…
-
EXP function for IBM Planning Analytics (TM1)
EXP function for IBM Planning Analytics (TM1) EXP returns the natural anti-log of a number. In the video, EXP will be used to calculate the anti-log value and apply it in the rule to populate the Product Scorecard cube. Where can the EXP function be used? Rules and TurboIntegrator Which TM1 Server version is the…
-
FEEDERS function for IBM Planning Analytics (TM1)
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…
-
ElParN Rules function for IBM Planning Analytics (TM1) – Rules
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 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?…