Monthly Archives: September 2014

ELPAR TM1 Function: Syntax and Use

ELPAR stands for Element Parent, which describes what it does pretty well! In other words it returns the parent of an element in a defined dimension. You are better to use a combination of attributes and ATTRS rather than this function. Please see our warning below. Syntax The syntax is: ELPAR(dimension, element, index), where: dimension is a valid dimension name, and element is the name of an element within the dimension or … Continue Reading

Cube Links – Avoiding Overlapping Links from Multiple Cubes

I have been trying to work out how to make rule driven links between two cubes work properly today.  One key thing that I have learnt from the Guru is to have separate elements in my Measures dimension for each source cube.  This is to avoid the situation where links from multiple cubes overlap the result in the target cube. For example, I have a GP cube, an Opex cube and a Factory … Continue Reading

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 … Continue Reading

What is a Set in a TM1 MDX Expression

A <set> in an MDX expression in TM1 refers to a group of elements.  Usually in TM1, this would be a subset in a dimension, although note that not all subsets are created by MDX.  So when using <set> in an MDX statement, usually you will refer to a subset of a dimension.

MDX in TM1 – a Basic Introduction

MDX in TM1 leverages of the standard MDX language (note leverages off, not uses). It is an industry standard query language for multi dimensional analysis. TM1 does not support the entire language and also adds on TM1 relevant features as well. Keeping Dimension Subsets Up to Date In a dimension, a great way to keep a subset up to date is to use MDX.  To do this enable the view of the … Continue Reading

Formatting a Cube to Display Thousands

I opened a cube the other day that had been created by someone else and was confounded for a short while about how it was formatted to display thousands, rather than units. Select the Measures Dimension, then tight click and Edit Element Attributes. Select the element you want to set, click the format button, choose Custom and paste #,###,;(#,###,) into the Custom Style.  This will then remove the last three digits … Continue Reading

Creating a TM1 Contributor Model

These are the steps I have just used to create my first TM1 Contributor model.  There are more steps here than in Performance Modeller, however I think this more complete list is more useful. Step 1 – Build Views and Websheets Build the Excel Websheets and TM1 Views you want to include in the Contributor model.  Note that all websheets and views must have the dimension you have defined for … Continue Reading

Now() TM1 Function: Syntax and Use

The Now function returns the current date-time stamp from the TM1 server Syntax of Now The syntax is Now();  There are no arguments. Usage of Now Typically Now(); will be used to store the current time in a numeric variable and then this will be addressed through other functions. For example nTimeNow = Now(); will store the current date-time stamp from the server in the variable nTimeNow. Now() can be used … Continue Reading

“C” for Clear or Zero (all child values in a cube)

In TM1, what’s the easy way to zero all the values in a cube, or all the child values of a parent? Easy, open the cube in Architect, navigate to the total you want to clear out and press “C”.You’ll then be asked if you want to perform a ‘Clear’ operation.  Say yes and Zap. Gone. All zeros. Too easy! Just as an aside, you can’t do it to an intersection … Continue Reading

DIMIX TM1 Function: Use and Syntax

DIMIX checks if an element exists in a dimension and if so, returns the index value of the element. If there is no element for the value being tested, it will return a 0. Syntax of DIMIX The syntax is DIMIX (dimension, element); where Dimension, is the name of the dimension you want to check Element, is the name of the element you are checking to see if it already … Continue Reading