TimSt function for IBM Planning Analytics (TM1) TimSt returns a formatted date/time in a string format. In this video, the TimSt function will be used to format a serial number to a date time format. Where can the TimSt function be used? Rules and TurboIntegrator Which TM1 Server version is the TimSt function available for?…

Trim function for IBM Planning Analytics (TM1) Trim removes any leading and trailing spaces from a string. In this video, Trim will be used to remove any leading and trailing spaces from a string and apply them to the rule to populate the Comment measure in the Product Scorecard cube. ​ Where can the Trim function be used? Rules and…

ChoreAttrPutN function for IBM Planning Analytics (TM1) ChoreAttrPutN uploads data to a numeric attribute for a Chore. In this video, ChoreAttrPutN is used to retrieve data from the string attribute, Description, for the ChoreFunction_Test chore, using language locale fr. Where can the ChoreAttrPutN function be used? TurboIntegrator Which TM1 Server version is the ChoreAttrPutN function available for? Version 11…

AttrPutN function for IBM Planning Analytics (TM1) AttrPutN is a TurboIntegrator function that uploads data to a numeric attribute for an element. If you want to upload data to a string attribute, use AttrPutS. In the video demo, learn how to use AttrPutN to update an attribute on the Weekday dimension. Where can the AttrPutN function…

CellGetN function for IBM Planning Analytics (TM1) CellGetN retrieves a numeric value from a cube cell. In this video, CellGetN is used to retrieve a value from the Product Scorecard cube. Where can the CellGetN function be used? TurboIntegrator Which TM1 Server version is the CellGetN function available for? Version 11 and 12 What is the syntax for…

CellGetS function for IBM Planning Analytics (TM1) CellGetS retrieves a string value from a cube cell. In this video, CellGetS is used to retrieve a cell storing strings from the Product Scorecard cube. Where can the CellGetS function be used? TurboIntegrator Which TM1 Server version is the CellGetS function available for? Version 11 and 12 What is the…

CellIncrementN function for IBM Planning Analytics (TM1) CellIncrementN increases a numeric value by a value. In this video, CellIncrementN is used to increment a cell by 500. Where can the CellIncrementN function be used? TurboIntegrator Which TM1 Server version is the CellIncrementN function available for? Version 11 and 12 What is the syntax for CellIncrementN?…

CellSecurityCubeCreate function for IBM Planning Analytics (TM1) CellSecurityCubeCreate creates cell security for a cube. In this video, CellSecurityCubeCreate is used to set up cell security for the Sales Quota cube. Where can the CellSecurityCubeCreate function be used? TurboIntegrator Which TM1 Server version is the CellSecurityCubeCreate function available for? Version 11 and 12 What is the syntax for…