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 – cannot convert field number 9! I initially thought it might concern field number 9 in my source data.  Nope.  No cigar! What this is saying is that there is a field on the Variables tab has been defined as … Continue Reading

This entry was posted in Errors, TI Errors. Bookmark the permalink. | Leave a comment

Cognos Express Backups: How to Create an Effective CX and TM1 Backup Strategy

Backing up your TM1 and/or Cognos Express environment is vital.  Without it, you potentially could lose months of work and cost your organisation a motza.  Good disaster recovery planning will help alleviate this risk. There is a Backup tool available in the Manager screen of Cognos Express that backs up and restores your entire Cognos Express environment.  Unfortunately this does not allow restoring of specific elements of your system.  Thus we … Continue Reading

This entry was posted in Backups, TM1 Administration. Bookmark the permalink. | Leave a comment

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 eh! And there are no operators. Usage Typically ITEMSKIP will be used with an IF statement so that only data that satisfies a certain criteria will be further processed. This both speeds up the processing and also allows you to discretely … Continue Reading

This entry was posted in TI Functions, TI Processes. Bookmark the permalink. | 1 Comment

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 length from a larger string of characters. Syntax of SUBST The syntax is SUBST(string, beginning, length); where string, is the text string that you want to take a slice out of beginning, is the numeric position in string where you want to start … Continue Reading

This entry was posted in Rule Functions, TI Functions. Bookmark the permalink. | 3 Comments

Accumulating Values for a Rolling Forecast

Mmmm.  Hard one.  How do I take a value and then use it for all periods from now on in a Rolling Forecast environment.  For example, I have a change I want to apply to a rate that is then to be used from now until the end of the rolling forecast. Year 2014 2015 Month Oct Nov Dec Jan Feb Mar Price             100             100             100             … Continue Reading

This entry was posted in Rule Examples. Bookmark the permalink. | Leave a comment

ProcessQuit TM1 Command: Use and Syntax

Ever wondered how you can stop a TI process?  Or if you haven’t thought of it, maybe you should have! When creating a Turbo Integrator process in TM1 you will often get part way through creating the code and need to test it.  It’s not really an issue when you have a short TI process, but if you are doing multiple steps in the TI or are addressing a large … Continue Reading

This entry was posted in TI Functions and tagged ProcessQuit. Bookmark the permalink. | Tagged ProcessQuit | 1 Comment

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 can easily restore from my backup. He gave me the following code that is to be inserted in the Prolog tab under Advanced in a Turbo Integrator process.  This creates a full archive of a TM1 Model (in this case CXMD) … Continue Reading

This entry was posted in TI Processes. Bookmark the permalink. | 1 Comment

CellIncrementN TM1 Function: Use and Syntax

CellIncrementN inserts a number into a specific intersection of a cube, adding onto any value that is already there. It does not overwrite that value, rather it increases it Syntax of CellIncrementN The syntax is CellIncrementN (Number, Cube, element1, element2, elementn ); where Number 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 the target cube element2 is an … Continue Reading

This entry was posted in TI Functions. Bookmark the permalink. | 1 Comment

Scan TM1 Function: Syntax and Use

Scan is a TM1 function that find the numeric position of the first instance of a specified substring within a string. If the substring is not found, it returns zero. It is essentially the same as the FIND command in Excel and CHARINDEX in SQL Server. Syntax of SCAN The syntax is: SCAN(substring, string); where substring is the substring you want to find string is the string you are evaluating both substring and … Continue Reading

This entry was posted in Rule Functions, TI Functions and tagged Scan, SubSt. Bookmark the permalink. | Tagged Scan, SubSt | Leave a comment

Using STET and CONTINUE in TM1 Rules

Often we want to tell TM1 to ignore this cell and move onto the next cell if a certain condition is met (or not met).  To do this we would typically create a rule with the syntax of if x is true, then continue processing, otherwise ignore this cell. Stet and Continue allow us to have this flexibility. Example of Stet and Continue in a TM1 Rule [ ] = … Continue Reading

This entry was posted in Rule Functions. Bookmark the permalink. | 1 Comment