Monthly Archives: February 2015
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.
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
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
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.