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…

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

AddCubeDependency function for IBM Planning Analytics (TM1) AddCubeDependency establishes cube dependency, triggered by a TurboIntegrator process. This function is a preemptive feature to prevent a potential lock on the TM1 Server during the system’s use, therefore the best time to use this function is when the server starts up. For reference, a lock occurs when…

SubSt function for IBM Planning Analytics (TM1) SubSt returns the substring of a specified string. In this video, SubSt will be used to repeat the string to extract the substring from a string and apply it in the rule to populate the Comment measure in the Product Scorecard cube.  Where can the SubSt function be used? Rules…

CellIsUpdateable function for IBM Planning Analytics (TM1) CellIsUpdateable checks whether a cube cell can be written to. If the cell can be written to, the function returns 1, otherwise a 0 is returned. In this video, CellIsUpdateable is used to load data to the Product Scorecard cube. CellIsUpdateable will be used to avoid cells that can’t be written to. Where can the…