ChoreAttrNL function for IBM Planning Analytics (TM1) ChoreAttrNL retrieves a numeric attribute for a Chore, based on a language locale. In this video, ChoreAttrNL is used to retrieve the numeric attribute, Frequency,  for the ChoreFunction_Test chore using language locale fr. Where can the ChoreAttrNL function be used? TurboIntegrator Which TM1 Server version is the ChoreAttrNL function available for? Version 11…

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

ChoreRollback function for IBM Planning Analytics (TM1) ChoreRollback terminates the chore and begins a rollback. In this video, ChoreRollback is used to terminate the chore and rollback data. Where can the AsciiDelete function be used? TurboIntegrator Which TM1 Server version is the ChoreRollback function available for? Version 11 and 12 What is the syntax for ChoreRollback?…

ElementWeight function for IBM Planning Analytics (TM1) ElementWeight returns the weight of a child element in a consolidation element. In the video, ElementWeight will be used to retrieve the weight of a child element of a consolidation of the Employee Hierarchies dimension and apply it in the rule to populate the Employee Salaries cube. Where…

ElIsAnc function for IBM Planning Analytics (TM1) ElIsAnc determines if an element is the ancestor of another element or not. In the video, ElIsAnc will be used to determine if the ‘Accessories’ consolidation is an ancestor or another element or not and apply it in the rule to populate the Comment measure in the Product Scorecard…

CellSecurityCubeDestroy function for IBM Planning Analytics (TM1) CellSecurityCubeDestroy deletes the cube’s cell security. In this video, CellSecurityCubeDestroy is used to delete the cell security for the Sales Quota cube.  Where can the CellSecurityCubeDestroy function be used? TurboIntegrator Which TM1 Server version is the CellSecurityCubeDestroy function available for? Version 11 and 12 What is the syntax for CellSecurityCubeDestroy ?…

ChoreAttrDelete function for IBM Planning Analytics (TM1) ChoreAttrDelete deletes an attribute for Chores. In this video, ChoreAttrDelete is used to delete the attribute, String Chore Attribute, for Chores.  Where can the ChoreAttrDelete function be used? TurboIntegrator Which TM1 Server version is the ChoreAttrDelete function available for? Version 11 and 12 What is the syntax for ChoreAttrDelete?…

ChoreAttrInsert function for IBM Planning Analytics (TM1) ChoreAttrInsert creates an attribute for Chores. In this video, ChoreAttrInsert is used to retrieve the numeric attribute, Frequency,  for the ChoreFunction_Test chore using language locale fr. Where can the ChoreAttrInsert function be used? TurboIntegrator Which TM1 Server version is the ChoreAttrInsert function available for? Version 11 and 12 What is the syntax for…

ConsolidateChildren function for IBM Planning Analytics (TM1) ConsolidateChildren forces consolidate value to be calculated by summing immediate children. In this video, ConsolidateChildren is used to calculate consolidated values by summing immediate children’s values and applying them in the rule to populate the Product Scorecard cube. Where can the ConsolidateChildren function be used? Rules Which TM1…

ConsolidatedAvg function for IBM Planning Analytics (TM1) ConsolidatedAvg returns the average value in a consolidation. In this video, ConsolidatedAvg is used to calculate average value  in a consolidation and apply it in the rule to populate the Avg_Value measure in the Product Scorecard cube.  Where can the ConsolidatedAvg function be used? Rules and TurboIntegrator Which TM1 Server version…