John
AttrPutS TM1 Function: Use and Syntax
AttrPutS is a TM1 Turbo Integrator function that inserts a string onto a specific attribute for the current element in a specified dimension. Note this does not insert a value…
AttrPutS TM1 Function: Use and Syntax
AttrPutS is a TM1 Turbo Integrator function that inserts a string onto a specific attribute for the current element in a specified dimension. Note this does not insert a value…
AttrPutS TM1 Function: Use and Syntax
AttrPutS is a TM1 Turbo Integrator function that inserts a string onto a specific attribute for the current element in a specified dimension. Note this does not insert a value…
DimensionSortOrder TM1 Function: Use and Syntax
DimensionSortOrder is used to sort a dimension from within a Turbo Integrator (TI) process. Syntax of DimensionSortOrder The syntax is: DimensionSortOrder ( DimName , CompSortType , CompSortSense , ElSortType , ElSortSense); …
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…
Attributes in TM1
I have been using attributes since I started working with TM1 and are often asked what are they and what are they used for. What are Attributes in TM1 TM1…
TI Error: Cannot convert field number 9
I was working on a new TI process today and got this error – “Cannot convert field number 9, value “*textdata*” to a real number”. Odd, I thought. Cryptic error…
Planning Analytics Backups: How to Create an Effective CX and TM1 Backup Strategy
Backing up your TM1 and/or Planning Analytics environment is vital. Â Without it, you potentially could lose months of work and cost your organisation a motza. Â Good disaster recovery planning will…
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…
SUBST TM1 Function (like Excel MID or SQL Server SUBSTR): Use and Syntax
The SUBST function is essentially the same as the Excel MID function or the SQL Server SUBSTR function, in that it allows you to select a group of characters of  a specified…
Keen to chat? Book a discovery call!