Monthly Archives: February 2015

Accumulating Values in TM1 for Rolling Forecast/Cashflow

Accumulating values in TM1 over multiple years. Cumulative values are very useful in a rolling forecast or cash flow calculation model. This shows in detail how to create a cumulative values with colour coded examples.

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

Incrementally increase the values in TM1 using CellIncrementN. As distinct form CellPutN, this function will increase the value at an intersection by incremental amounts using the value being loaded rather than replace the original value at the intersection.

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