The EXECUTEPROCESS function is used to call and run a TurboIntegrator (TI) processe from within another TurboIntegrator processes. This function will run the process identified within the parentheses along with any specified parameters that follow.     The first argument in the function will be the process that is going to be executed. The only…

The DIMIX function is a helpful function that can be used in TurboIntegrator (TI) processes and TM1 rules. Simply put, the function will return the index number of an element within a dimension. If the element does not exist in the dimension, the function will return with a 0.     The first argument in…

While is a Turbo Integrator (TI) function that is widely used to “loop” through data repeatedly, without wrapping multiple processes together to accomplish the same goal. Below is the syntax: Define loop iteration element WHILE ( logical expression ); Statements; loop iteration; END; Let’s illustrate it by using a simple WHILE loop example: We want…

Did you know that Planning Analytics has a build in scheduling functionality call Chores? Chores can be used in two distinct ways; you can schedule one or more TurboIntegrator processes to execute at defined intervals or you can setup a sequence of TurboIntegrator process to be execute by a user. These two concepts can be…

Did you know you can use Planning Analytics’ drill-through feature to access detailed data in another Planning Analytics cube or a configured relational table? This feature can allow for a user to quickly find detailed information underlying a data point which is either in the model in a more detailed cube, or not in Planning…

You’ve created some basic rules and feeders against one of your Planning Analytics cubes and have used the SKIPCHECK and FEEDERS declarations (best practice).  But what does FEEDSTRINGS do and do you need it? The FEEDSTRINGS declaration makes sure any STRING cells in a cube that need to be calculated by a rule are fed.…

IBM Planning Analytics Workspace (PAW) is a web-based interface for IBM Planning Analytics. It delivers an intuitive interface to the data residing in Planning Analytics (TM1), providing ways to plan, create, and analyze your content by providing features such as conditional formatting and calculations. One interesting feature available in PAW, is the ability to perform searches entered in…

The ASCIIOutput function creates a comma-delimited record in an ASCII output file. This function is a TurboIntegrator function and it can be used to export data, debug a TurboIntegrator process, or generate an ASCII file for many purposes. This article will show the syntax of this function and some examples of its arguments. In addition,…

The short answer is Yes! These are invaluable elemental information functions within Planning Analytics. These functions can be used in Rules, Worksheets, and TI Processes. ELPAR and ELCOMP are very similar to one another and have other related functions which can return information about how elements reside within dimensions. In this post, I will discuss…

ELISANC is one of the more versatile functions in Planning Analytics. The function determines whether the first element is an ancestor of the second element. This function returns 1 if the relationship is true, and it returns 0 if the relationship is not true. Although ELISANC can be used in rules and TurboIntegrator (TI), we…