HierarchySubsetDestroy function for IBM Planning Analytics (TM1) HierarchySubsetDestroy destroys a subset from a hierarchy. In this video, HierarchySubsetDestroy will be used to remove the Departments subset associated with the Employee hierarchy and Employee dimension.  Where can the HierarchySubsetDestroy function be used? TurboIntegrator Which TM1 Server version is the HierarchySubsetDestroy function available for? Version 11 and 12 What is the syntax for…

ServerSandboxGet function for IBM Planning Analytics (TM1) ServerSandboxGet 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, ServerSandboxGet will be used to return the 3rd sandbox for the user running the process. Where can the ServerSandboxGet function be used? TurboIntegrator Which…

ProcessAttrNL function for IBM Planning Analytics (TM1) ProcessAttrNL retrieves data from a numeric attribute for a process, given a language locale.  In this video, ProcessAttrNL will be used to retrieve the Reference Number from the TrainingProcess process Where can the ProcessAttrNL function be used? TurboIntegrator Which TM1 Server version is the ProcessAttrNL function available for? Version 11 and 12 What…

ServerSandboxesDelete function for IBM Planning Analytics (TM1) ServerSandboxesDelete allows administrators to delete user sandboxes from the TM1 server.   In this video, ServerSandboxesDelete will be used to delete the sandbox, Test, from the user Test. Where can the ServerSandboxesDelete function be used? TurboIntegrator Which TM1 Server version is the ServerSandboxesDelete function available for? Version 11 and 12 What is…

ProcessExists function for IBM Planning Analytics (TM1) ProcessExists checks if a process exists. 1 is returned if the process exists, 0 if it does not exist. If a process exists but has compilation errors, -1 is returned. In this video, ProcessExists is used to check if the process, TrainingProcess, exists on the TM1 Server. Where can the…

ServerSandboxExists function for IBM Planning Analytics (TM1) ServerSandboxExists checks if a sandbox exists for a user. It returns a numeric value of 1 if the sandbox exists or 0 if it does not exist. In this video, ServerSandboxExists will be used to check if the sandbox Training exists. Where can the ServerSandboxExists function be used? TurboIntegrator Which TM1…

HierarchySubsetAttrDelete function for IBM Planning Analytics (TM1) HierarchySubsetAttrDelete deletes a subset attribute from a hierarchy in a dimension. In this video, HierarchySubsetAttrDelete will be used to delete Office subset attribute from the Western Europe hierarchy in the Sales Region dimension. Where can the HierarchySubsetAttrDelete function be used? TurboIntegrator Which TM1 Server version is the HierarchySubsetAttrDelete function available for? Version 11 and…

SaveDataAll function for IBM Planning Analytics (TM1)  SaveDataAll saves all changes made on the TM1 server. This moves the changes from memory to disk and restarts the log file. In the video, SaveDataAll will be used to save all changes on the TM1 Server and show how it impacts log files. Where can the BatchUpdateFinishWait function…

SecurityOverlayCreateGlobalDefault function for IBM Planning Analytics (TM1) SecurityOverlayCreateGlobalDefault creates a Security Overlay cube for a specific cube with a dimension map based on the dimension order in the cube. A security Overlay cube locks and unlocks specific intersections at the cell level according to the combination of dimension elements assigned. In the video, SecurityOverlayCreateGlobalDefault will be used…

SecurityOverlayDestroyGlobalDefault function for IBM Planning Analytics (TM1) SecurityOverlayDestroyGlobalDefault deletes the Security Overlay cube for a specific cube with a dimension map based on the dimension order in the cube.  In the video, SecurityOverlayDestroyGlobalDefault will be used to delete the Security Overlay for the ‘General Ledger’ cube (}SecurityOvelayGlobal_General Ledger) from the TM1 database. Where can the SecurityOverlayDestroyGlobalDefault function be…