ServerSandboxDiscardAllChanges function for IBM Planning Analytics (TM1) ServerSandboxDiscardAllChanges discards all changes for a given sandbox owned by the user who executed the process. In this video, ServerSandboxDiscardAllChanges will be used to discard all changes made on the sandbox, Goal. Where can the ServerSandboxDiscardAllChanges function be used? TurboIntegrator Which TM1 Server version is the ServerSandboxDiscardAllChanges function available…

ASIN function for IBM Planning Analytics (TM1) ASIN returns the angle, in radians, whose sine is x. In the video, ASIN will be used to calculate the angle of a given sine value.  Where can the ASIN function be used? Rules and TurboIntegrator Which TM1 Server version is the ASIN function available for? Version 11 and…

ServerSandboxClone function for IBM Planning Analytics (TM1) ServerSandboxClone creates a sandbox that is a copy of an existing one.  In this video, ServerSandboxClone will be used to create a new sandbox, Goal, from the existing sandbox, Training. Where can the ServerSandboxClone function be used? TurboIntegrator Which TM1 Server version is the ServerSandboxClone function available for? Version 11 and 12…

ViewMDXGet function for IBM Planning Analytics (TM1)  ViewMDXGet retrieves the MDX expression for a cube view. In the video, ViewMDXGet will be used to retrieve the MDX used for the view, My new MDX View, from the Finance cube. Where can the ViewMDXGet function be used? TurboIntegrator Which TM1 Server version is the ViewMDXGet function available for?…

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…

SubsetElementGetIndex function for IBM Planning Analytics (TM1) SubsetElementGetIndex retrieves an element’s index in a subset. If the element doesn’t exist in the subset, then the function returns 0. If the index is not between 1 and the size of the subset then the function return error and process will be aborted.  In this video, SubsetElementGetIndex will be used to retrieve…

SubsetElementInsert function for IBM Planning Analytics (TM1) SubsetElementInsert adds an element in an existing subset. In this video, SubsetElementInsert will be used to insert the element, Sales Amount, to the ‘All Elements’ subset in the Product Scorecard dimension into position 1 and 3 Where can the SubsetElementInsert function be used? TurboIntegrator Which TM1 Server version…

TM1User function for IBM Planning Analytics (TM1) TM1User returns the client who ran the process. In this video, TM1User is used to retrieve the client who ran the process. Where can the TM1User function be used? Excel and TurboIntegrator Which TM1 Server version is the TM1User function available for? Version 11 and 12 What is the…