DimensionAttrN function for IBM Planning Analytics (TM1) DimensionAttrN returns a numeric attribute for a specified dimension. In this video, DimensionAttrN will be used to retrieve the numeric attribute value of the dimension and apply it in the rule to populate the Product Scorecard cube.  Where can the DimensionAttrN function be used? Rules and TurboIntegrator Which TM1…

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

ElementAttrN function for IBM Planning Analytics (TM1) ElementAttrN returns the numeric attribute value of the specified element of a dimension. In the video, ElementAttrN will be used to retrieve the Employee Hierarchies dimension numeric attribute value and apply it in the rule to populate the Employee Salaries cube. Where can the ElementAttrN function be used? Rules…

ElIsPar Rules function for IBM Planning Analytics (TM1) ElIsPar determines if an element is the parent of another element or not. In the video, ElIsPar will be used to determine if the ‘All Products by Category’ element is a parent or another element or not and apply it in the rule to populate the Comment…

ElementAttrS function for IBM Planning Analytics (TM1) ElementAttrS deletes an attribute for a dimension. In the video, ElementAttrS will be used to retrieve the Employee Hierarchies dimension string attribute value and apply it in the rule to populate the Employee Salaries cube.​ Where can the ElementAttrS function be used? Rules and TurboIntegrator Which TM1 Server…

Continue function for IBM Planning Analytics (TM1) Continue allows a subsequent rule within the same intersection to be executed. In this video, Continue is used to execute subsequent rules and apply them in the rule to populate the Commission measure in the Product Scorecard cube.  Where can the Continue function be used? Rules and TurboIntegrator…

COS function for IBM Planning Analytics (TM1) COS returns the cosine of an angle expressed in radians. In the video, COS will be used to calculate the cosine of an angle of given radians.  Where can the COS function be used? Rules and TurboIntegrator Which TM1 Server version is the COS function available for? Version 11 and…

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

ElCompN Rules function for IBM Planning Analytics (TM1) ElCompN returns the name of the child of a consolidated element. In the video, ElCompN will be used to determine the number of elements of the consolidation and apply it in the rule to populate the Product Scorecard cube. ​ Where can the ElCompN function be used? Excel, Rules…

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