ServerActiveSandboxGet function for IBM Planning Analytics (TM1) ServerActiveSandboxGet returns the name of the active sandbox for the user. If no sandbox is set as active, the function returns a blank string.  In this video, ServerActiveSandboxGet will be used to get the user’s active sandbox name. Where can the ServerActiveSandboxGet function be used? TurboIntegrator Which TM1 Server…

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…

ConsolidatedCount function for IBM Planning Analytics (TM1) ConsolidatedCount returns the number of values in a consolidation. In this video, ConsolidatedCount is used to count the number of values in the consolidation and apply it in the rule to populate the Avg_Value element in the Product Scorecard cube.  Where can the ConsolidatedCount function be used? Rules and TurboIntegrator Which…

ConsolidatedMax function for IBM Planning Analytics (TM1) ConsolidatedMax returns the maximum value in a consolidation. In this video, ConsolidatedMax is used to calculate maximum value in a consolidation and apply it in the rule to populate the Max_Value measure in the Product Scorecard cube.  Where can the ConsolidatedMax function be used? Rules and TurboIntegrator Which TM1 Server version…

ConsolidatedMin function for IBM Planning Analytics (TM1) ConsolidatedMin returns the minimum value in a consolidation. In this video, ConsolidatedMin is used to calculate minimum value in a consolidation and apply it in the rule to populate the Min_Value measure in the Product Scorecard cube.  Where can the ConsolidatedMin function be used? Rules and TurboIntegrator Which TM1 Server version…

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 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 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 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…