How to Create Virtual Dimensions in TM1/Planning Analytics
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.
Days in Month – How to Easily Calculate in a TM1 Rule
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.
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!
DimensionCreate: How to Create a Dimensions in a TM1 Process (TI)
To create a dimension in a TM1 model use the DimensionCreate function in Turbo Integrator processes. Combine with IF and DimensionExists.
DimensionExists: Checking if a Dimension is in TM1
To check if a dimension already exists in a TM1 model use the DimensionExists function in Turbo Integrator processes. Combine with IF and DimensionCreate.
How to use Operators in TM1 Rule IF Statements
Explanation and Example of “AND” and “OR” Operators in IF statements in TM1 Rules.
Operators in a TM1 Turbo Integrator IF Statement
Have you ever wanted to add SQL like operators directly to your TI processes? Operators like OR, AND, NOT IN, or NOT EQUAL TO. Well here’s how you can.
DIMIX TM1 Function: How to Use, Syntax & Examples
An in depth explanation of the usage of the DIMIX Function in Turbo Integrator Processes and Rules in TM1 and Planning Analytics. In short, to assess if a variable exists as either an element or an alias in a TM1 dimension.
IF Function in Turbo Integrator processes in TM1: How to Use and Syntax
IF() Function for use in Turbo Integrator (TI) Processes in TM1 and Planning Analytics for setting up Conditional Statements in TI Processes.
ELISANC TM1 Function: How to Use, Syntax and Example
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.
Three TM1 Rules All Developers Should Know
Here we discuss how to do three rules, all that should be in your TM1 kitbag. These include Allocation/Phase Rule, Rolling Value Rule and Averaging Rule (C Level). There are full explanations and the code used for the rule examples.