ProcessAttrSL function for IBM Planning Analytics (TM1) ProcessAttrSL retrieves data from a string attribute for a process, based on a language locale. In this video, ProcessAttrSL will be used to retrieve the string attribute, Description, for the TrainingProcess process Where can the ProcessAttrSL function be used? TurboIntegrator Which TM1 Server version is the ProcessAttrSL function available for? Version 11…

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

ServerSandboxCreate function for IBM Planning Analytics (TM1) ServerSandboxCreate creates a new Sandbox for the user. In this video, ServerSandboxCreate will be used to create a new sandbox called Training. Where can the ServerSandboxCreate function be used? TurboIntegrator Which TM1 Server version is the ServerSandboxCreate function available for? Version 11 and 12 What is the syntax for ServerSandboxCreate? ServerSandboxCreate(SandboxName)…

DimensionElementInsert function for IBM Planning Analytics (TM1)  DimensionElementInsert adds an element in a dimension. This action occurs after a commitment to the process (e.g., at the end of executing the metadata tab). To action this function immediately, use DimensionElementInsertDirect. In the video, the DimensionElementInsert will be used to insert Wales before Scotland in the Sales Region dimension. Where can the DimensionElementInsert function be used? TurboIntegrator…

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…

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…