Tag Archives: IF
Virtual Dimensions in TM1 and Planning Analytics allow you to use Attributes to create additional analytic capability. Here we explain how to create them with code examples.
Here we explain how to calculate the number of days in each month with a simple, but easy rule, using the DAYNO function and a Next Month attribute.
Here is how to simply delete a single element from a dimension in TM1. Note DimensionElementDelete permanently deletes the element from the dimension and all associated data from any cube the dimension is used in – so please be careful!
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.
Explanation and Example of “AND” and “OR” Operators in IF statements in TM1 Rules.
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
DIMIX Function: Explanation and Use in Turbo Integrator Processes and Rules in TM1 and Planning Analytics to assess if a variable exists as either an element or an alias in a TM1 dimension.
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 Function for use in Rules and TI Processes in TM1 and Planning Analytics to test if one element is an ancestor of another. In other words, if one element is higher in a hierarchy than another element.