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…

UnDef function for IBM Planning Analytics (TM1) UnDef returns the undefined value. In this video, UnDef is used to return the undefined value and apply it in the rule to populate in the Product Scorecard cube.  Where can the UnDef function be used? Rules and TurboIntegrator Which TM1 Server version is the UnDef function available for?…

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…

UndefVals function for IBM Planning Analytics (TM1) UndefVals changes the default value for the cube from zero to a special undefined value. In this video, UndefVals is used to change the default value from zero to undefined value. ​ Where can the UndefVals function be used? Rules and TurboIntegrator Which TM1 Server version is the UndefVals function available…

Upper function for IBM Planning Analytics (TM1) Upper converts text characters to upper case. In this video, Upper will be used to convert lower case characters to upper case and apply it in the rule to populate the Comment measure in the Product Scorecard cube.  ​ Where can the Upper function be used? Rules and TurboIntegrator Which TM1 Server…

Lower function for IBM Planning Analytics (TM1) Lower converts text characters to lower case. In this video, Lower will be used to convert upper case characters to lower case and apply it in the rule to populate the Comment measure in the Product Scorecard cube.  Where can the Lower function be used? Rules and TurboIntegrator Which TM1 Server version…

Stet function for IBM Planning Analytics (TM1) Stet cancels the effect of the rule for a specified element.  In this video, Stet is used to cancel the effect of the rule for a specified element and apply it to the Product Scorecard cube rule.  Where can the Stet function be used? Rules Which TM1 Server…

MIN function for IBM Planning Analytics (TM1) MIN returns the smallest number between two numbers. In the video, MIN will be used to determine the smallest number between two numbers and be applied to the rule to populate the MIN_Value measure in the Product Scorecard cube. Where can the MIN function be used? Rules and TurboIntegrator Which TM1…