-
HierarchyN function for IBM Planning Analytics (TM1)
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 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 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 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 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…
-
INT function for IBM Planning Analytics (TM1)
INT function for IBM Planning Analytics (TM1) INT returns the largest value that is less than or equal to a specified value. In the video, INT will be used to show both positive and negative argument values. Where can the INT function be used? Rules and TurboIntegrator Which TM1 Server version is the INT function…
-
ElPar Rules function for IBM Planning Analytics (TM1)
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…
-
ISUND function for IBM Planning Analytics (TM1)
ISUND function for IBM Planning Analytics (TM1) ISUND returns 1 if the argument value is undefined. In the video, ISUND will be used to check whether a cell value contains an undefined value and apply it in the rule to populate the Product Scorecard cube. Where can the ISUND function be used? Rules and TurboIntegrator…
-
Long function for IBM Planning Analytics (TM1)
Long function for IBM Planning Analytics (TM1) Long returns the length of the string. In this video, Long will be used to retrieve the length of a string and apply it in the rule to populate the Comment measure in the Product Scorecard cube. Where can the Long function be used? Rules and TurboIntegrator Which TM1 Server version…
-
SKIPCHECK function for IBM Planning Analytics (TM1)
SKIPCHECK function for IBM Planning Analytics (TM1) SKIPCHECK forces the TM1 engine to skip the check of all N-level empty cells in a cube. In this video, SKIPCHECK will be used to skip the check of all N-level empty cells in a Product Scorecard cube. Where can the SKIPCHECK function be used? Rules Which TM1 Server…