carryforward ending balance to beginning balance

Post Reply
Posts: 128
Joined: Tue May 23, 2017 12:45 pm
OLAP Product: Tm1
Version: 9.5
Excel Version: 2010

carryforward ending balance to beginning balance

Post by Analytics123 » Sat Sep 16, 2017 7:38 pm


I am planning to write a ti process to carry forward ending balance to beginning balance of next month via ti.
I have my data starting july 2015 in my cube , i should now start carry forward july ending balnce as august beginning balance .

For this I will create a ti with datasource as a view with july data as initial step and load august . to iterate next month should I update the month subset and change the data source ?


Wim Gielis
Posts: 1748
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0
Excel Version: 2016
Location: Brussels, Belgium

Re: carryforward ending balance to beginning balance

Post by Wim Gielis » Sat Sep 16, 2017 8:09 pm


The view for your datasource needs to be scripted using parameters such as pYear and pMonth.
Then in the Advanced > Data tab, do a CellPutN using an attribute on the Month / Period / ... dimension, to know the "Next Month".
Also, in the Prolog tab, you will need to a zero out of the data in the Next month (use the attribute as suggested above).
Best regards,

Wim Gielis

Excel Most Valuable Professional, 2011-2014 ==> 105 TM1 articles and a lot of custom code
Newest blog article: Looping over input files

Post Reply