ExecuteProcess function for IBM Planning Analytics (TM1)

Where can the ExecuteProcess function be used?

TurboIntegrator

Which TM1 Server version is the ExecuteProcess function available for?

Version 11 and 12

What is the syntax for ExecuteProcess?

ExecuteProcess(ProcessName, [ParamName1, ParamValue1, ParamName2, ParamValue2])

• ​ProcessName = Process to execute.​
• ParamName1= Name of the first parameter. ​
• ParamValue1= The value of the first parameter. ​
• ParamName2= Name of the second parameter. 
• ParamValue2= The value of the second parameter. 

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