-
ViewColumnDimensionSet function for IBM Planning Analytics (TM1)
ViewColumnDimensionSet function for IBM Planning Analytics (TM1) ViewColumnDimensionSet sets the dimension in a column position for a cube view. In the video, ViewColumnDimensionSet will be used to set the dimension Year in the column position for the default view as the top-most stacked position. Where can the ViewColumnDimensionSet function be used? TurboIntegrator Which TM1 Server version is the ViewColumnDimensionSet function…
-
AttrN function for IBM Planning Analytics (TM1)
AttrN function for IBM Planning Analytics (TM1) AttrN returns the numeric attribute for a specified element of a dimension. This function can be used to enhance data analysis, improve report quality and create more sophisticated calculations. In the video, AttrN will be used to retrieve an attribute’s value from the Organisation dimension. Where can the AttrN function be…
-
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…
-
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?…
-
CellValueN function for IBM Planning Analytics (TM1)
CellValueN function for IBM Planning Analytics (TM1) CellValueN returns the numeric value of the specified element in a specified cube. In this video, CellValueN is used to retrieve data from Value to TestN in the Product Scorecard cube. Where can the CellValueN function be used? Rules Which TM1 Server version is the CellValueN function available for? Version 11 and 12 What…
-
DimensionAttrN function for IBM Planning Analytics (TM1)
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 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?…
-
Day function for IBM Planning Analytics (TM1)
Day function for IBM Planning Analytics (TM1) Day returns the day from a date in a numeric format. In this video, the Day function will be used to retrieve the day from a date. Where can the Day function be used? Rules and TurboIntegrator Which TM1 Server version is the Day function available for? Version…
-
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…