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…

ATAN function for IBM Planning Analytics (TM1) ATAN returns the angle, in radians, whose tangent is x. In the video, ATAN will be used to calculate the angle in radians of a given tangent value. Where can the ATAN function be used? Rules and TurboIntegrator Which TM1 Server version is the ATAN function available for? Version 11 and…

CubeAttrInsert function for IBM Planning Analytics (TM1) CubeAttrInsert creates a new attribute for Cubes. In the video, CubeAttrInsert will be used to create the attribute, Description, for Cubes. Where can the CubeAttrInsert function be used? TurboIntegrator Which TM1 Server version is the CubeAttrInsert function available for? Version 11 and 12 What is the syntax for CubeAttrInsert?…

AttrS function for IBM Planning Analytics (TM1) AttrS retrieves the string attribute from an element in a dimension. This function can be used in a Rule or TurboIntegrator, as the syntax is the same. AttrS is often used to retrieve properties, such as the description or category. Learn how to use AttrS as a Rule…

CubeExists function for IBM Planning Analytics (TM1) CubeExists is used to check if a cube exists on the TM1 Server. In this video, CubeExists is used to check whether the Product Scorecard cube exists on the server. Where can the CubeExists function be used? TurboIntegrator Which TM1 Server version is the CubeExists function available for? Version 11 and…

CreateHierarchyByAttribute function for IBM Planning Analytics (TM1) CreateHierarchyByAttribute creates a hierarchy composed of three levels. The lowest level is the N element, the first parent is a given attribute, and the top level is given by a parameter. The new hierarchy will have the same name as the given attribute. In the video, CreateHierarchyByAttribute will…