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…

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 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…

FEEDSTRINGS function for IBM Planning Analytics (TM1) FEEDSTRINGS enables the feeding of string cells. In this video, FEEDSTRINGS will be used to enable the feeding of string cells and feed the comment measure of the Product Scorecard cube.  Where can the FEEDSTRINGS function be used? Rules Which TM1 Server version is the FEEDSTRINGS function available…

Fill function for IBM Planning Analytics (TM1) Fill repeats a string to the specified number of lengths. In this video, Fill will be used to repeat the string to the specific length and apply it in the rule to populate the Comment measure in the Product Scorecard cube.  Where can the Fill function be used? Rules and TurboIntegrator…

FV function for IBM Planning Analytics (TM1) FV returns the future value of an annuity at the time of the last payment.  In this video, FV will be used to calculate the future value of an annuity and apply it in the rule to populate the Commission measure in the Product Scorecard cube.  Where can the…

Hierarchy function for IBM Planning Analytics (TM1) Hierarchy returns the name of the hierarchy if there is only one hierarchy at the dimension; otherwise, it returns an empty string. In this video, Hierarchy will be used to retrieve the Employee Hierarchies dimension hierarchy name and apply it in the rule to populate the Employee Salaries cube.​​…

HierarchyCount function for IBM Planning Analytics (TM1) HierarchyCount returns the number of hierarchies in the supplied dimension. In this video, HierarchyCount will be used to retrieve the Employee Hierarchies dimension number of the hierarchy and apply it in the rule to populate the Employee Salaries cube. Where can the HierarchyCount function be used? Rules Which…

PV function for IBM Planning Analytics (TM1) PV returns the initial or principal value of an annuity.  In this video, PV will be used to calculate the payment value of an annuity and apply it in the rule to populate the Product Scorecard cube.  Where can the PV function be used? Rules and TurboIntegrator Which…

Scan function for IBM Planning Analytics (TM1) Scan searches the specified substring within a string and returns the starting position of the substring. In this video, Scan will be used to find the substring within a string and apply it in the rule to populate the Commission measure in the Product Scorecard cube.  Where can the Scan function…