IF function for IBM Planning Analytics (TM1)

Where can the IF function be used?

TurboIntegrator

Which TM1 Server version is the IF function available for?

Version 11 and 12

What is the syntax for IF?

IF (expression);​
  statement;​
ELSEIF (expression);​
  statement;​
ELSE;​
  statement;​
ENDIF;​

• ​​expression = A logical expression to check if it is true or not.​
• statement = a statement to be executed if the expression is true

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