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…

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…

SecurityOverlayGlobalLockCell function for IBM Planning Analytics (TM1) SecurityOverlayGlobalLockCell locks or unlocks a specific intersection or cell in the cube based on the combination of dimension elements assigned in the Security Overlay cube of a specific cube. In the video, SecurityOverlayGlobalLockCell will be used to lock ‘Budget 2002’ cells for data entry in the ‘Sales Quota’ cube. Where can…

SecurityOverlayGlobalLockNode function for IBM Planning Analytics (TM1) SecurityOverlayGlobalLockNode locks or unlocks a specific intersection or cell in the cube based on the combination of dimension elements assigned in the Security Overlay cube of a specific cube. In the video, SecurityOverlayGlobalLockNode will be used to lock the ‘Actual 2020’ and ‘Budget 2002’ cells for data entry in the…