Tag Archives: IF
To create a dimension in a TM1 model use the DimensionCreate function in Turbo Integrator processes. Combine with IF and DimensionExists.
To check if a dimension already exists in a TM1 model use the DimensionExists function in Turbo Integrator processes. Combine with IF and DimensionCreate.
Do you need to create an IF expression in a TM1 rule with a logical operator? To create something that is like and AND or OR from SQL but do it in a Rule? Look no further! If, however, you are looking for IF operators for a Turbo Integrator process, please check this post. TM1 Rule Operators There are some very useful operators available in TM1 Rules. Use For OR, … Continue Reading
Ever wanted to create a command similar to an SQL “IS IN” in a TM1 Turbo Integrator process? Or use operators in a TM1 TI process to create a “NOT IN” like command from a SQL? Or wanted to use an OR, an AND or a NOT EQUAL TO command in a TI process? Well, you can. If you are looking for the operators to use in a TM1 Rule, please check … Continue Reading
IF() is a function that can be used to test if an expression is true so that you can then differentially execute another function based on the outcome of the IF statement. It is able to be used in both Turbo Integrator processes and Rules, however, this post is about the use of it in TI’s only. For Rule-based IF statements, please see this post. Syntax of IF() for Turbo … Continue Reading
ELISANC stands for ELelemnt IS ANCestor, in other words, is one element in a dimension an ancestor of another. In other words, it is testing to see if one element is the child of another and return either a 1 if it is true or a 0 if false. Syntax of ELISANC The syntax is ELISANC (dimension, element1, element 2); where you are testing if element1 is the ancestor of element2 … Continue Reading