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…

MOD function for IBM Planning Analytics (TM1) MOD returns the remainder after a number is divided by a divisor.  In the video, MOD will be used to calculate the remainder and apply it to the rule to populate the amount measure in the Product Scorecard cube.  Where can the MOD function be used? Rules and…

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

PAYMT function for IBM Planning Analytics (TM1) PAYMT returns the payment amount of an annuity based on the principal amount, rate, and number of periods. In this video, PAYMT 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 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…

UndefinedCellValue function for IBM Planning Analytics (TM1) UndefinedCellValue returns the default numeric cube value. In this video, UndefinedCellValue is used to retrieve the default value of a cube and apply it in the rule to populate the Product Scorecard cube.  Where can the UndefinedCellValue function be used? Rules and TurboIntegrator Which TM1 Server version is…