# Tag Archives: IF

## DimensionElementDelete Function TM1: Syntax and Use

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!

This entry was posted in TI Functions and tagged DIMENSIONELEMENTCOMPONENTDELETE, DimensionElementDelete, DimensionElementInsert, dimix, IF. Bookmark the permalink. | | 1 Comment

## Using the DimensionCreate Function to Create a Dimension in TM1

To create a dimension in a TM1 model use the DimensionCreate function in Turbo Integrator processes. Combine with IF and DimensionExists.

This entry was posted in Dimensions, TI Functions and tagged Dimension, DimensionCreate, DimensionExists, IF, TI Process, Turbo Integrator. Bookmark the permalink. | | Leave a comment

## Checking if a DimensionExists in a TM1 Model

To check if a dimension already exists in a TM1 model use the DimensionExists function in Turbo Integrator processes. Combine with IF and DimensionCreate.

This entry was posted in Dimensions, TI Functions and tagged Dimension, DimensionCreate, DimensionExists, IF, TI Process, Turbo Integrator. Bookmark the permalink. | | Leave a comment

## Operators in TM1 Rule IF Statements

Explanation and Example of “AND” and “OR” Operators in IF statements in TM1 Rules.

This entry was posted in Rule Examples, Rule Functions and tagged IF, operators, Rules. Bookmark the permalink. | Tagged IF, operators, Rules | Leave a comment

## Operators in TI IF Statements

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 …

This entry was posted in TI Coding, TI Functions, TI Variables and tagged IF, operators. Bookmark the permalink. | Tagged IF, operators | 1 Comment

## IF() TM1 TI Function: Use and Syntax

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 …

This entry was posted in TI Functions and tagged DimensionElementInsert, IF. Bookmark the permalink. | Tagged DimensionElementInsert, IF | 12 Comments

## ELISANC TM1 Function: Use and Syntax

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 …

This entry was posted in Rule Functions, TI Functions and tagged ELISANC, IF. Bookmark the permalink. | Tagged ELISANC, IF | 3 Comments