ELPAR TM1 Function: How to Use and Syntax
ELPAR is a TM1 worksheet function for showing the parent value of an element. This explains the syntax and use of ELPAR, however it is better to use ATTRS.
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 […]
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.
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 – an Introduction
Here’s how to create dynamic subsets in TM1 by using recorded MDX, with an explanation of MDX.
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 […]
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 […]
"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. […]
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.
NOW() TM1 Function: Syntax and Use
The now() function returns a value corresponding with the number of days from either 1 January 1960 or 1 January 1900. It’s the same as the Excel now() function.
"cell type is real" TM1 Error
I got a “cell type is real” error this afternoon and was somewhat confounded! “cell type is real” was in the TM1 error log when I after I ran a TI process that was pasting a string into a cube. The error was caused by the element I was trying to write to being defined as a […]
AsciiOutput TM1 Function: Use and Syntax
Have you ever wanted an easy way to output data from TM1 so you could then either reload it back into TM1 or load it into your ERP system or load it to an external database for example? Well, you can. The TM1 function ASCIIOUTPUT allows you to do exactly that. Syntax of ASCIIOutput The syntax is: ASCIIOutput […]
CellPutN TM1 Function: Use and Syntax
CellPutN Function for use in TI Processes in TM1 to update a cell with a numeric value via a Turbo Integrator process. This replaces the value already in the intersection.
CellPutS TM1 Function: Use and Syntax
CellPutS inserts a string into a specific intersection of a cube. It does not insert numeric values. Syntax of CellPutS The syntax is CellPutS (String, Cube, element1, element2, elementn ); where string is the string you want to insert into a cube cube is the cube you insert the string into element1 is an element from the first dimension of […]
Running a TI Process from within another Process
In TM1 often we want to have a master process which then calls child processes. There is a Turbo Integrator command that allows us to nest TM1 processes. It is called ExecuteProcess. Syntax of ExecuteProcess ExecuteProcess ( processname, paramater1name, parameter1value, parameter2name, parameter2value, parameterNname, parameterNvalue ); where: processname is the name of the process you want to […]
CellGetN TM1 Function: How to Use and Syntax
CellGetN gets a number from a specific intersection of a cube from within a Turbo Integrator process. It can be used as in a similar way to a DB function in a TM1 Rule. Also, don’t confuse it with ‘CellGetS‘ (which retrieves strings) – that just won’t work with numbers! Syntax of CellGetN The syntax is: Where cube is the cube you want to get […]
NumberToString TM1 Function: How to Use and Syntax
NumberToString Function for use in Turbo Integrator processes in TM1 and Planning Analytics to convert numbers to text (or strings). From here you can use it with other strings or output to a text file.
ExecuteProcess TM1 Function: How to Use, Example and Syntax
ExecuteProcess (not ProcessExecute) function for use in Turbo Integrator Processes in TM1 and Planning Analytics to execute another TI process.
Indenting TI Processes and Rules in TM1
How to use indents to layout Rules and Turbo Integrator processes in TM1 so they are easier to read.
First TM1 Feeder!
So I just added my first ever Feeder in TM1. Woah, that was confusing. But I’ll get over it and it worked first go! Let me explain. I have a cube, Opex, that is to be used in a rolling forecast model for forecasting Operating Expenses. I have a Scenario dimension with Actual and Current […]
