-
AddCubeDependency function for IBM Planning Analytics (TM1)
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 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…
-
CellPutS function for IBM Planning Analytics (TM1)
CellPutS function for IBM Planning Analytics (TM1) CellPutS writes a string value to a cube cell. In this video, CellPutS is used to update comments for the Bike Racks product category. Where can the CellPutS function be used? TurboIntegrator Which TM1 Server version is the CellPutS function available for? Version 11 and 12 What is the syntax for CellPutS?…
-
CellPutProportionalSpread function for IBM Planning Analytics (TM1)
CellPutProportionalSpread function for IBM Planning Analytics (TM1) CellPutProportionalSpread proportionally spreads a value to the children of a consolidation. In this video, CellPutProportionalSpread is used to show how data is spread to a cell with no underlying and no data. Where can the CellPutProportionalSpread function be used? TurboIntegrator Which TM1 Server version is the CellPutProportionalSpread function…
-
TimSt function for IBM Planning Analytics (TM1)
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 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…
-
CellIsUpdateable function for IBM Planning Analytics (TM1)
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…
-
CellPutN function for IBM Planning Analytics (TM1)
CellPutN function for IBM Planning Analytics (TM1) CellPutN writes a numeric value to a cube cell. In this video, CellPutN is used to write a value to the Bike Racks product category. Where can the CellPutN function be used? TurboIntegrator Which TM1 Server version is the CellPutN function available for? Version 11 and 12 What is the…
-
ChoreAttrPutN function for IBM Planning Analytics (TM1)
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 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…