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

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…

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…

ConsolidatedCountUnique function for IBM Planning Analytics (TM1) ConsolidatedCountUnique counts the unique elements of the consolidated cell in one dimension. In this video, ConsolidatedCountUnique is used to count the unique elements in the consolidation and apply it in the rule to populate in the Product Scorecard cube.  Where can the ConsolidatedCountUnique function be used? Rules and TurboIntegrator Which…

CubeAttrS function for IBM Planning Analytics (TM1) CubeAttrS returns a string attribute for a specified cube. In the video, CubeAttrS will be used to retrieve string attribute value of the cube and apply it in the rule to populate the Comment measure in the Product Scorecard cube.  Where can the CubeAttrS function be used? Rules and…

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