-
CubeAttrN function for IBM Planning Analytics (TM1)
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…
-
Date function for IBM Planning Analytics (TM1)
Date function for IBM Planning Analytics (TM1) Date returns the date in a string yy-mm-dd format. In this video, the Date function will be used display the date in the System info cube. Where can the Date function be used? Rules and TurboIntegrator Which TM1 Server version is the Date function available for? Version 11 and…
-
Dates function for IBM Planning Analytics (TM1)
Dates function for IBM Planning Analytics (TM1) Dates returns the date in a string yy-mm-dd or yyyy-mm-dd format. In this video, the Dates function will be used to display the desired date. Where can the Dates function be used? Rules and TurboIntegrator Which TM1 Server version is the Dates function available for? Version 11 and 12 What…
-
ElementIndex function for IBM Planning Analytics (TM1)
ElementIndex function for IBM Planning Analytics (TM1) ElementIndex returns the index number of an element within a dimension. In the video, ElementIndex will be used to retrieve the index number of an element of the Employee Hierarchies dimension and apply it in the rule to populate the Employee Salaries cube. Where can the ElementIndex function be used? Rules and…
-
ElementIsComponent function for IBM Planning Analytics (TM1)
ElementIsComponent function for IBM Planning Analytics (TM1) ElementIsComponent determines if the element is a child of a consolidation or not. The function returns 1 if the element is a child of consolidation. In the video, ElementIsComponent will be used to determine if an element is a child of consolidation and will be applied in the rule…
-
ElementIsParent function for IBM Planning Analytics (TM1)
ElementIsParent function for IBM Planning Analytics (TM1) ElementIsParent determines if an element is the parent of another element or not. In the video, ElementIsParent will be used to determine if an element is a parent or another element and apply it in the rule to populate the Comment measure in the Employee Salaries cube. Where…
-
ElementLevel function for IBM Planning Analytics (TM1)
ElementLevel function for IBM Planning Analytics (TM1) ElementLevel returns the level of an element within a dimension. In the video, ElementLevel will be used to retrieve the element’s level and apply it in the rule to populate the Employee Salaries cube. Where can the ElementLevel function be used? Rules and TurboIntegrator Which TM1 Server version…
-
ElementNext function for IBM Planning Analytics (TM1)
ElementNext function for IBM Planning Analytics (TM1) ElementNext returns the element that follows the specified element of a dimension. In the video, ElementNext will be used to retrieve the element’s following element name of the dimension and apply it in the rule to populate the Employee Salaries cube. Where can the ElementNext function be used? Rules…
-
ElementParent function for IBM Planning Analytics (TM1)
ElementParent function for IBM Planning Analytics (TM1) ElementParent returns the parent of an element in the dimension. In the video, ElementParent will be used to return an element’s first parent. The result will be stored in the Employee Salaries cube. Where can the ElementParent function be used? Rules and TurboIntegrator Which TM1 Server version is the…
-
DimNm function for IBM Planning Analytics (TM1) – Rules
DimNm function for IBM Planning Analytics (TM1) – Rules DimNm returns an element’s member ID based on an index in a dimension. In the video, DimNm will be used on the Year dimension to return the element’s primary name based on an index. Where can the DimNm function be used? Excel, Rules and TurboIntegrator Which…