TM1 Forum

Hi,

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 ?

Thanks

Hello,

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).