<iframe src="https://www.googletagmanager.com/ns.html?id=GTM-NCX94J4" height="0" width="0" style="display:none;visibility:hidden"></iframe>

Sleep function for IBM Planning Analytics (TM1)

    Sleep pauses a process for a specified interval.

    In this video, Sleep is used to pause a process for 5 seconds.

    Where can the Sleep function be used?

    TurboIntegrator

      Which TM1 Server version is the Sleep function available for?

      Version 11 and 12

        What is the syntax for Sleep?

        Sleep(ms)

        • ​ms = Number of milliseconds to pause the process

        Relevant Functions

        • DataMinorErrorCount = Counts minor errors that occur in Data tab
        • ExecuteCommand = Executes a command line
        • ExecuteHttpRequest = Executes an HTTP request to a server over the web, enabling the retrieval of web pages, data and other resources
        • ExecuteJavaN = Executes a Java TurboIntegrator process that returns a number
        • ExecuteJavaS = Executes a Java TurboIntegrator process that returns a string
        • ExecuteProcess = Executes a process
        • GetProcessErrorFileDirectory = Returns the full path name, with trailing slash, of the directory where error files are written
        • GetProcessErrorFilename = Returns the name of the error log file associated with the process
        • GetProcessName = Returns the name of the process
        • HttpResponseGetStatusCode = returns the status code
        • HttpResponseGetHeader = returns content from the header
        • HttpResponseGetBody = returns content from the body
        • If = Uses a conditional expression to check if an expression is true or false
        • ItemReject = Skips the current source data transaction like ItemSkip
        • ItemSkip = Skips the current transaction in the process
        • MetadataMinorErrorCount = A global variable that counts minor errors that occur in the Metadata portion in a process
        • ProcessBreak = Stops processing any data and moves straight to the Epilog
        • ProcessError = Immediately terminates the process and produces an error
        • ProcessExists = Checks if a process exists. 1 is returned if the process exist, 0 if it does not exist
        • ProcessExitByChoreRollback = triggers a chore rollback and exits with an error code that discards all pending edits and stops further processing in a TurboIntegrator process.
        • ProcessExitByProcessRollback = triggers a process rollback and exits with an error code that discards all pending edits and stops further processing in a TurboIntegrator process.
        • ProcessQuit = Immediately terminates the process and returns a Process Quit message
        • ProcessReturnCode = A global variable that stores the exist status of the most recently executed process
        • ProcessRollback = Terminates the process and begins a rollback
        • PrologMinorErrorCount = A global variable that counts minor errors that occur in the Prolog
        • RunProcess = Run multiple processes in parallel. This function can speed up data loads and other processes by dividing work into multiple parts
        • Sleep = Pauses a process for a specified interval
        • Synchronized = Forces processes to run in sequence
        • While = Repeats a set of command until a condition is true