TI Processes
We’re the experts in corporate financial management and business analytics you’ve been searching for.
Our team of talented accountants can help you find and use the tools you need to make your budgeting, forecasting analysis and reporting world class.
TM1 SaveDataAll Data Locks
Recently I encountered a situation where we had a SaveDataAll process running every half hour that had started impacting the system performance. The environment is largely for enterprise planning and we…
Exporting Data from TM1 to an External Database
I needed to create a rollup in a data warehouse the other day from elements that are stored in TM1. This process works just as well for SQL Server, Oracle,…
DatasourceNameForServer and DatasourceNameForClient TM1 Functions: Use and Syntax
Ever wondered how you can vary the data source for a Turbo Integrator process inside the actual process so it becomes dynamic? Well here is a method. Firstly, define a…
ELLEV TM1 Function: Use and Syntax
The ELLEV function returns the numeric value of the level for an element in a dimension in TM1. Syntax The syntax is ELLEV(dimension, element); where: dimension, is the dimension you are…
How to Pad a Variable Length Element in TM1
Often we have a situation were we want to create a dimension with the contents of a code from a source system. Sometimes, however the IDs in the source system are…
ItemSkip TM1 Function: Use and Syntax
ITEMSKUP is a Turbo Integrator function that forces the current record being read from a data source to be skipped. Syntax of ITEMSKIP The syntax is just ITEMSKIP; – real simple…
TM1 Archive TI Process
I asked Mafia Man the other day how I can take a backup on the fly of everything in TM1 so that if I make changes and stuff up, I…
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…
Annotations in TI Processes
When you first open up a Turbo Integrator script you will notice the text at the top of the Advanced tab tabs with a “#” in front of each line to show…
.pro files (no, not profiles, but “.pro files”
.pro files are a magic little file that is saved in the TM1 data folder (along with dimensions, models, feeders, cubes etc). You can read them with a text editor…
Need help with TM1?
We're here for you
Keen to chat? Book a discovery call!