-
DB function for IBM Planning Analytics (TM1)
DB function for IBM Planning Analytics (TM1) DB retrieve a value from a cube cell. In this video, DB is used to multiply the Sales Quota Budget values from January by the Monthly Growth in the Sales Assumption cube. Where can the DB function be used? Rules Which TM1 Server version is the DB function available…
-
CapIt function for IBM Planning Analytics (TM1)
CapIt function for IBM Planning Analytics (TM1) CAPIT capitalises the first letter of every word in a string. CAPIT can be useful to standardise the appearance of object names when the data is not presented uniformly. Utilising this function with inconsistent formatting would help clean up the presentation, making it easier for users to digest. In…
-
Delet function for IBM Planning Analytics (TM1)
Delet function for IBM Planning Analytics (TM1) Delet function deletes a specified number of characters from a specified position within a string. In this video, Delet is used to remove characters from the string and apply them to the rule to populate the Comment measure in the Product Scorecard cube. Where can the Delet function be used?…
-
ElCompN Rules function for IBM Planning Analytics (TM1)
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 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…
-
ElementAttrN function for IBM Planning Analytics (TM1)
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 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 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 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 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…