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…

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…

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…

CubeDRReleaseAll function for IBM Planning Analytics (TM1) CubeDRReleaseAll releases all the data reservations specified in the element list. This function applies to dimensions with one or more hierarchies, while CubeDataReservationReleaseAll is used for dimensions with a single hierarchy. Learn how to use the CubeDRReleaseAll to release all data reservations for everyone in the Product Type by Region cube. Where can the CubeDRReleaseAll…

DimensionCreate function for IBM Planning Analytics (TM1)  DimensionCreate creates a new dimension. In the video, the DimensionCreate will be used to create a dimension called ‘A New Dimension’. Where can the DimensionCreate function be used? TurboIntegrator Which TM1 Server version is the DimensionCreate function available for? Version 11 and 12 What is the syntax for DimensionCreate?…

CubeClearData function for IBM Planning Analytics (TM1) CubeClearData clears all the data for a Cube. In this video, CubeClearData is used to clear all the data in the Product Scorecard_Copy cube. Where can the CubeClearData function be used? TurboIntegrator Which TM1 Server version is the CubeClearData function available for? Version 11 and 12 What is the syntax…