Monthly Archives: February 2015

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